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?
A:
You can do this using Excel's automation features from any language that supports COM (directly or indirectly); here's an example using VB.Net. There are also examples using VB6 out there still, but see my comment on your question, creating new applications with VB6 is a potential problem as the dev environment (compiler, for instance) is no longer supported (the runtime still is, for a little while yet, to support apps that already exist). The dev environment still works (under XP, at least) to my (sad) knowledge, but expect it to start having trouble as OS's move on...
T.J. Crowder
2010-03-15 08:51:09
VB6 Dev environment and runtime still works under Windows 7.But VB6 cannot compile to 64 bit so VB6 compiled COM addins will not work with the 64-bit version of Excel 2010.VBA Macros and addins on the other hand are fully supported in 64-bit Excel (there is a new 64-bit version of the VBA runtime).
Charles Williams
2010-03-15 10:57:19
You must be a sad sad person...
wqw
2010-03-19 12:41:05