ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XML Importing Problem (https://www.excelbanter.com/excel-programming/416946-xml-importing-problem.html)

Melissa M

XML Importing Problem
 
I'm attempting to import XML data onto a worksheet in Excel 2003. If I create
the VBA procedure and run it, it works just fine, as long as don't close down
the application. However, if I do close down Excel, re-open it, then attempt
to run my procedure, I get a run-time error: -2147217376 (80041020). The
description says, "A string literal was expected, but no opening quote
character was found."

The code line looks like this (with, of course, a valid address):
ActiveWorkbook.XmlImport URL:= "http://..._getCPdata?year=2009&&" _
, ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$1")

I've run out of things to try - anyone have any clue as to what I can do?



All times are GMT +1. The time now is 07:25 PM.

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