View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default ActiveWorkbook.XmlImport?

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?