Problem importing file -- PLEASE HELP

[warren_s]

Looking for ideas / suggestions.

I have an exported xml file I am getting from another system. When I try to import it into a worksheet as an xml file, it errors out saying the file may be corrupt and bombs. I do know that the file has char 160’s in it which I think it causing the issue.

When I file open it using file, open file, it opens but pops up an error that I have to click on acknowledging it may be corrupt. After I hit ok, it imports fine.

Does anyone have an idea on how I can import this file into an existing worksheet in a specific worksheet?

Any ideas / vba code to do this would be greatly appreciated.

Thank you in advance.

Warren

 

[sandy666]

you didn't show the error
and if this possible could you attach link to the shared xml file via googledrive, onedrive, dropbox or any other similar service

 

[warren_s]

This is what I am getting using file open. When I say yes it loads fine.
When I try to import it, it says it is corrupted and bombs.

 

[warren_s]

The sheet is going to be distributed so doing the data from a drive and linking to it will not work

 

[sandy666]

but, as I can see, this is old excel format .xls not xml,
xls is a binary file so you cannot extract xml from this like from newer xlsx files
try open , confirm you agree, then try export/save as xml

or just save xls as xlsx
all try on copy !

 

[warren_s]

Do you happend to have the VBA code to select the file and import it into a specific work sheet by any luck?
So it will pop the selector, let them find the file and import it

 

[sandy666]

you'll need to wait for someone else who will give you vba solution. I am away from vba, sorry