LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS OFFICE EDITION 2003 Bill Excel Worksheet Functions 2 September 19th 08 12:09 AM
MS Office multiuser edition? OO Excel Discussion (Misc queries) 4 February 8th 08 10:45 PM
new office 2007 home edition kay Excel Discussion (Misc queries) 0 August 1st 07 10:18 PM
Do I have excel I run Office xp home edition ninjanewfie Excel Discussion (Misc queries) 2 May 14th 06 04:44 AM
OFFICE STANDARD EDITION Donna Setting up and Configuration of Excel 0 January 28th 05 01:21 AM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"