ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Managing Excel from VB^ (https://www.excelbanter.com/excel-programming/355671-managing-excel-vbulletin%5E.html)

Uwe

Managing Excel from VB^
 
If I add Excell 11 to my VB6 project but code the objects for late binding
and remove the reference when I compile, will this maintain compatibility
with older versions of excel when the exe is installed on user systems?
I'm thinking that this way I have all the references available in the object
browser when I write the code.
--
Thanks,
Uwe

Jon Peltier

Managing Excel from VB^
 
Uwe -

This is exactly what we do. But you should try to program with the Excel 9
library referenced, so you don't inadvertently use one of the few items
added to Excel VBA after Excel 2000.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Uwe" wrote in message
...
If I add Excell 11 to my VB6 project but code the objects for late binding
and remove the reference when I compile, will this maintain compatibility
with older versions of excel when the exe is installed on user systems?
I'm thinking that this way I have all the references available in the
object
browser when I write the code.
--
Thanks,
Uwe




basilio

Managing Excel from VB^
 
I have seen your answer to another member .
I would appreciate to know how to transform excel files to executable.
thanks
--
Basilio


"Uwe" wrote:

If I add Excell 11 to my VB6 project but code the objects for late binding
and remove the reference when I compile, will this maintain compatibility
with older versions of excel when the exe is installed on user systems?
I'm thinking that this way I have all the references available in the object
browser when I write the code.
--
Thanks,
Uwe



All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com