Thread: Accessing different versions of Excel VBA from another application
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie[_2_] David McRitchie[_2_] is offline
external usenet poster
  
Posts: 134
Default Accessing different versions of Excel VBA from another application
Hi Bradley,
msgbox "Excel Version = " & Application.Version
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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?




Reply With QuoteReply With Quote