MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
I have this code which was working fine last week but today is giving me the following error
Run-time error -2147217376 (80041020) Automation Error
Anybody know why or how to overcome it, the code is just importing an XML file into excel
Please help, thank you
Run-time error -2147217376 (80041020) Automation Error
Anybody know why or how to overcome it, the code is just importing an XML file into excel
Code:
Application.CutCopyMode = False
Application.CutCopyMode = False
ActiveWorkbook.XmlImport [URL="https://www.mrexcel.com/forum/=ThisWorkbook.Sheets("Links_&_Paths").Range("RefinedXML"]Url:=ThisWorkbook.Sheets("Links_&_Paths").Range("RefinedXML[/URL]")
, ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$1")
Please help, thank you