Excel 2003 Maps

[Guest]

I have recently upgraded from Office 2000 to office 2003.
I have Excel worksheets containing VBA macros which maps create maps from the data. These worked fine under Office 2000, but now produce a "Run time error 1004 - cannot insert object".

This is the line of code which produces the error:
set oleobj=ActiveSheet.OleObjects.Add(Classtype:="MSMap.8")

Excel for Office 2000 has a component called Microsoft Map but I need to know the equivalent component for Excel 2003, or how to change the code above to work in Excel 2003.

 

[JulieD]

Hi

i looked this up in help the other day and found the "useful" comment of:
The Map tool is no longer available with Excel 2003. You may not be able to
open files created with the Map Tool unless you have an earlier version of
Microsoft Office installed.

.... so AFAIK you can't do it anymore

Cheers
JulieD

I have recently upgraded from Office 2000 to office 2003.
I have Excel worksheets containing VBA macros which maps create maps from

the data. These worked fine under Office 2000, but now produce a "Run time
error 1004 - cannot insert object".

This is the line of code which produces the error:
set oleobj=ActiveSheet.OleObjects.Add(Classtype:="MSMap.8")

Excel for Office 2000 has a component called Microsoft Map but I need to

know the equivalent component for Excel 2003, or how to change the code
above to work in Excel 2003.

 

[Gord Dibben]

Take a look at this google search thread result for workarounds.

http://snipurl.com/88ah




On Wed, 4 Aug 2004 04:15:05 -0700, "A Zolna" <A