How can I make reference to older EXCEL versions
I have Excel 2003 (v 11) on my machine but the machine that the VB exe will operate on has on older version of Excel. What do I do to make the reference links work in this case? :confused:
I tried to put a copy of his excel.exe file on my PC and link a reference to that but it did not work.
There has to be a way!
Someone please help me. An email to [email address removed] with any advise is also greatly appreciated!!!!
Re: How can I make reference to older EXCEL versions
I have edited your post and removed your email address.
You should never post your email address in an open post on an open forum. Mail spam bots can pick that up and before you know it, your mailbox is full of junk mail. If you wish to share your email address with other forum members, please do so via our PM system.
Thanks. :)
Re: How can I make reference to older EXCEL versions
Just use Late Binding - see the Excel Tutorial link in my signature for an explanation of how to do it. :)
Re: How can I make reference to older EXCEL versions
Any version of Excel or other Office apps are not redistributable. Use Late Binding like in Si's tutorial. Just make sure your only using functions and methods that are common and supported by the versions you want to support.