Posted
by Mark
on Stack Overflow
See other posts from Stack Overflow
or by Mark
Published on 2010-03-15T08:42:36Z
Indexed on
2010/03/15
8:49 UTC
Read the original article
Hit count: 748
i have an excel file template and i want save the written value in textboxes to the cells of excel using vb6 language.
can anyone help me?
© Stack Overflow or respective owner
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a VB6 App that uses a .Net component (via a .tlb reference in the VB6 app) which is working fine when executed as a compiled app, but it produces an error from the VB6 IDE a certain point when it is trying to use the .NET component.
I should note that the error occurs when the .NET component…
>>> More
as seen on Developper.com
- Search for 'Developper.com'
Bonjour à tous!
Voici un article sur la programmation des extensions OpenGL, en VB6/VBA
Cet article décrit l'utilisation de quelques extensions fréquemment utilisées :
- Les VBO (vertex buffer objects) pour améliorer les performances
- Les textures 3D pour réaliser des textures continue sur…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a VB6 dll that is loaded by a VB6 frontend. This VB6 dll calls a C++ ATL dll via its COM interface. So, I can run from code in VB6 and I can debug in C++ also, however I can't seem to step through the VB6 code and then get into the C++ code. I feel that this should be possible. Currently I…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i have an excel file template and i want save the written value in textboxes to the cells of excel using vb6 language.
can anyone help me?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello
I have a .NET DLL that writes to the Trace. But seems that when I call my DLL from a VB6 EXE the trace is not working.
I have created an myApp.config file in the EXE folder with the trace configuration, but this does not solves the issue.
I've also tried creating the Trace objects in code…
>>> More
