ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel.xmlMap not defined (https://www.excelbanter.com/excel-programming/330532-excel-xmlmap-not-defined.html)

irfan

Excel.xmlMap not defined
 
hi,
I am using Add - referance - Excel 11.0 Object library to refer to Excel
2003(standard edition) in VB6 Express edition.
But when it gives an error when i try to declare an instance od xmlMap
Dim map As Excel.xmlmap // ERROR: Type Excel.xmlMap not defined.

Any help is appreciated:

Irfan





Tom Ogilvy

Excel.xmlMap not defined
 
Perhaps the Edition of Excel in the standard edition is not the same as that
in the Professional edition. From help on xmlmap:

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.



--

Regards,

Tom Ogilvy





"Irfan" wrote in message
...
hi,
I am using Add - referance - Excel 11.0 Object library to refer to

Excel
2003(standard edition) in VB6 Express edition.
But when it gives an error when i try to declare an instance od xmlMap
Dim map As Excel.xmlmap // ERROR: Type Excel.xmlMap not defined.

Any help is appreciated:

Irfan







irfan

Excel.xmlMap not defined
 
Tom,
Thanks for the reply. I was also about to conclude the same. But, could
someone in the group also reiterate this fact that in order to use xml
feature in excel object 2003, i should upgrade to professional edition.


secondly, what about the enduser when they use the application. Do they
need to have a Office professional edition 2003 or standard edition will do
?

Also, what about the users who are still using 2000, 2002. Will my
application run on those systems.

TIA
Irfan



"Tom Ogilvy" wrote in message
...
Perhaps the Edition of Excel in the standard edition is not the same as
that
in the Professional edition. From help on xmlmap:

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.



--

Regards,

Tom Ogilvy





"Irfan" wrote in message
...
hi,
I am using Add - referance - Excel 11.0 Object library to refer to

Excel
2003(standard edition) in VB6 Express edition.
But when it gives an error when i try to declare an instance od xmlMap
Dim map As Excel.xmlmap // ERROR: Type Excel.xmlMap not defined.

Any help is appreciated:

Irfan










All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com