View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Bill Barclift Bill Barclift is offline
external usenet poster
 
Posts: 23
Default Accessing different versions of Excel VBA from another application

I would still approach it this way. Get a copy of someones older Excel type
library file called Excel8.olb or Excel9.olb. Put it on your computer (you
don't need to do anything with it, just get a copy of it) and reference it
before you save the Autocad file. This should work fine for your users. (I
haven't tried this in VBA but have done it many times in VB....I think it
should work fine in VBA, as well)

Bill Barclift


"Bradley Dawson" wrote in message
...
I like that, but the office computer is up to date and only references the
latest version, user's home computer's usually have older versions. Also,
once the program is run on a newer version, that seems to become the
reference and won't run on older versions.
Since I'm a newbie, I'll have to read up on this "binding" that I have
skipped over so much. Thanks for the help.

"Bill Barclift" wrote in message
...
Late binding WILL cause a perforance hit.....depending on your

particular
application, this may or may not be acceptable. I would early bind and
reference an earlier version of Excel (like 97 or 2000, assuming you

don't
use any features not supported by these apps). If the user has a new
version of Excel you will be fine.

Bill Barclift


"Tom Ogilvy" wrote in message
...
Use late binding - don't have a reference to excel.

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever

Possible


--
Regards,
Tom Ogilvy


Bradley Dawson wrote in message
...
I often run Excel VBA applications from AutoCAD, but the reference

to
Excel
is particular to the company's computer that I use. When it is run

on
another computer with a different version of Excel, the application

fails.
Is there a way to check for Excel versions and apply the correct
application
reference?