ActiveWorkbook.XmlImport?

HotRod

Guest

Posts: n/a

8th May 2007

I was given a workbook that uses ActiveWorkbook.XmlImport but it doesn't
seem to be an option for me in excel. What am I missing? I'm using excel
2000 if that makes a difference. I can execute the created URL in IE

http://geocoder.ca/?stno=75&addresst...al=6&geoit=XML

but in VBA I just get the error. "Object doesn't support this property or
method"

What do I need to reference? Is there a way to do this in code?

« How do I go from time to decimal if over 24hrs | Using VBA to Populate a Calendar Template »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
XmlImport Problem in Excel 2007	ROHAN	Microsoft Excel Misc	0	11th Oct 2008 01:54 PM
Using XmlImport to get dynamic data in Excel 2003	Gokul	Microsoft Excel Programming	0	17th Dec 2007 04:53 PM
Quick XmlImport Compatibility issue	Kigol	Microsoft Excel Programming	4	5th Jun 2007 01:25 PM
Using XmlImport/Export Fucntions for excel	=?Utf-8?B?VW1haXIgSGFzYW4=?=	Microsoft Excel Programming	0	18th Aug 2006 02:06 PM
ActiveWorkBook	Pete	Microsoft Excel Misc	3	9th May 2005 04:14 PM