Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to obtain Excel (or Office) FULL Version?

Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default How to obtain Excel (or Office) FULL Version?

Hi Bathan,

Bathan wrote:
Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but
not the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.


You can get the major version # and the build # by using the Version and
Build properties of the Application object:

Debug.Print Application.Version
Debug.Print Application.Build

This will help you determine what version and SP level the user is on:

http://support.microsoft.com/kb/821549

I'm not sure how you would go about determining the "type" of Excel install
(ie, basic, pro, dev). Maybe the registry would have what you need?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Common\ProductVersion\ProInfo

Or you could enumerate the subkeys of:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Registration

And look for one with "ProductNameNonQualified" = "Microsoft Office 2003".
Then look for a value in that key named "ProductName", which for me is
"Microsoft Office Professional Edition 2003".

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default How to obtain Excel (or Office) FULL Version?

"Professional" or "Basic" (or "Small Business Edition," for that
matter) refer to Office editions and not Excel editions. Excel in all
Office 2003 installations are fundamentally the same, the differences
being whether any Service Packs or Add-ins are installed. We use all
three Office editions, and Excel is exactly the same version in every
installation.

Bathan wrote:

Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default How to obtain Excel (or Office) FULL Version?

Bathan,
What difference would this information make for you ?

NickHK

"Bathan" wrote in message
oups.com...
Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to obtain Excel (or Office) FULL Version?

The thing is that we use XML Maps on excel to generate some reports.

Excel Basic (sp1 and/or 2) doesnt seem to have this option.

I get an error message when i try to do this:

ListObject oList = oSheet.ListObjects[ 1 ];

oList.XmlMap.ImportXml( xml, true );

The error message is (!exactly byt close) : "This feature is only
available on Office 2003 Professional".

Additionally, if I open my Excel template with Excel Basic(we have
templates with lists mapped to XML DataSources) i cannot find the XML
SubMenu on "Data" menu , it simply does not exist.

So basically, it seems that to work with XML I need Office 2003 Pro :)

Thanks a lot for all the tips!!!

NickHK wrote:
Bathan,
What difference would this information make for you ?

NickHK

"Bathan" wrote in message
oups.com...
Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default How to obtain Excel (or Office) FULL Version?

Bathan,
There is no "Excel Basic" v. "Excel Pro". That applies to Office.
I imagine most people buy the whole Office suite, but (in the past anyway)
you can buy Excel, Word, etc separately. So I suppose it possible for to
have mix of of Office app installed. What this would mean for the version of
Office, I have no idea.
As for the SP installed for a particular version/app, see:
http://support.microsoft.com/kb/255275
Whilst this applies to Office 2000, I imagine a similar mix applies to later
versions.

You could start a WB that only uses features supported on all versions and
check the version of Excel installed and/or the version of MSOx.dll.
If 2003, open the WB that uses these XML features. If not, inform the user
their system is not compatible and exit.

NickHK

"Bathan" wrote in message
ups.com...
The thing is that we use XML Maps on excel to generate some reports.

Excel Basic (sp1 and/or 2) doesnt seem to have this option.

I get an error message when i try to do this:

ListObject oList = oSheet.ListObjects[ 1 ];

oList.XmlMap.ImportXml( xml, true );

The error message is (!exactly byt close) : "This feature is only
available on Office 2003 Professional".

Additionally, if I open my Excel template with Excel Basic(we have
templates with lists mapped to XML DataSources) i cannot find the XML
SubMenu on "Data" menu , it simply does not exist.

So basically, it seems that to work with XML I need Office 2003 Pro :)

Thanks a lot for all the tips!!!

NickHK wrote:
Bathan,
What difference would this information make for you ?

NickHK

"Bathan" wrote in message
oups.com...
Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but

not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!




  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default How to obtain Excel (or Office) FULL Version?

I got this from Microsoft's Office 2003 information doc (emphasis
mine):

"Although XML is implemented in *ALL* the Microsoft® Office 2003
Editions, this chapter focuses on XML implementation in Office
Professional 2003."

I can find no mention anywhere of differences between versions of Excel
in the various editions of Office 2003. Could it be an add-in issue?

Bathan wrote:
The thing is that we use XML Maps on excel to generate some reports.

Excel Basic (sp1 and/or 2) doesnt seem to have this option.

I get an error message when i try to do this:

ListObject oList = oSheet.ListObjects[ 1 ];

oList.XmlMap.ImportXml( xml, true );

The error message is (!exactly byt close) : "This feature is only
available on Office 2003 Professional".

Additionally, if I open my Excel template with Excel Basic(we have
templates with lists mapped to XML DataSources) i cannot find the XML
SubMenu on "Data" menu , it simply does not exist.

So basically, it seems that to work with XML I need Office 2003 Pro :)

Thanks a lot for all the tips!!!

NickHK wrote:
Bathan,
What difference would this information make for you ?

NickHK

"Bathan" wrote in message
oups.com...
Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!


  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default How to obtain Excel (or Office) FULL Version?

I took a closer look at our installations and it seems that there are
indeed differences in XML capability in Excel in the various versions
of Office 2003. To wit: It's available in Office 2003 Professional
and not in the Basic or Small Business editions.

From Excel Help: "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."

Based on what I see now, I'd guess that means you can get XML features
only in Office 2003 Pro or in the *standalone* version of Excel.

I hope I don't have to start using XML features soon....

Sorry to mislead you in my earlier post.

Bathan wrote:
The thing is that we use XML Maps on excel to generate some reports.

Excel Basic (sp1 and/or 2) doesnt seem to have this option.

I get an error message when i try to do this:

ListObject oList = oSheet.ListObjects[ 1 ];

oList.XmlMap.ImportXml( xml, true );

The error message is (!exactly byt close) : "This feature is only
available on Office 2003 Professional".

Additionally, if I open my Excel template with Excel Basic(we have
templates with lists mapped to XML DataSources) i cannot find the XML
SubMenu on "Data" menu , it simply does not exist.

So basically, it seems that to work with XML I need Office 2003 Pro :)

Thanks a lot for all the tips!!!

NickHK wrote:
Bathan,
What difference would this information make for you ?

NickHK

"Bathan" wrote in message
oups.com...
Hi!

Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but not
the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

Thanks!!


Reply
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
Excel version in Office Home & Student full featured?? bobber Excel Discussion (Misc queries) 1 December 8th 09 09:43 PM
What version of Excel comes with Office 2003? Tom Excel Discussion (Misc queries) 4 July 28th 09 01:25 AM
What version of Excel comes with Office 2004 for Mac? jetsonsally Excel Discussion (Misc queries) 2 May 9th 06 03:43 PM
can i load full version of excel on to a ipaq unit ej Excel Discussion (Misc queries) 3 January 29th 05 06:52 PM
Obtain full path to a directory pk Excel Programming 2 September 29th 03 07:07 PM


All times are GMT +1. The time now is 10:02 AM.

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

About Us

"It's about Microsoft Excel"