Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
Using Excel 2003 I created a spreadsheet using XML import and export. The
help information says the following on the XML features in Excel 2003: * Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003. I'd want to inform the user whether the XML features will work or not. Using "Application.Version" I get the Excel version. Does anyone know how to test the office edition in VBA? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
If val(application.Version)10 Then
MsgBox "XML works" End If -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hypernikao" wrote in message ... Using Excel 2003 I created a spreadsheet using XML import and export. The help information says the following on the XML features in Excel 2003: * Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003. I'd want to inform the user whether the XML features will work or not. Using "Application.Version" I get the Excel version. Does anyone know how to test the office edition in VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
In a post from Michel Pierron I read about the property
Application.ArbitraryXMLSupportAvailable This will tell me what I need to know. Thank you Michel! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
At home I have Microsoft Office Excel 2003 (so version 11.0) and Microsoft
Office Basic Edition. Your code will not work for this situation. Thanks anyway for your reply Bob. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
Why not? It tests for 10, and guess what, 11 is 10.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hypernikao" wrote in message ... At home I have Microsoft Office Excel 2003 (so version 11.0) and Microsoft Office Basic Edition. Your code will not work for this situation. Thanks anyway for your reply Bob. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I test in VBA what edition of Office a user is running
But that errors in 2002 and before.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hypernikao" wrote in message ... In a post from Michel Pierron I read about the property Application.ArbitraryXMLSupportAvailable This will tell me what I need to know. Thank you Michel! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS OFFICE EDITION 2003 | Excel Worksheet Functions | |||
MS Office multiuser edition? | Excel Discussion (Misc queries) | |||
new office 2007 home edition | Excel Discussion (Misc queries) | |||
Do I have excel I run Office xp home edition | Excel Discussion (Misc queries) | |||
OFFICE STANDARD EDITION | Setting up and Configuration of Excel |