Problem importing file -- PLEASE HELP

warren_s

Board Regular
Joined
May 28, 2007
Messages
73
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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

Board Regular
Joined
May 28, 2007
Messages
73
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.

1600655349315.png
 

warren_s

Board Regular
Joined
May 28, 2007
Messages
73
The sheet is going to be distributed so doing the data from a drive and linking to it will not work
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499

ADVERTISEMENT

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
saxml.png

or just save xls as xlsx
all try on copy !
 
Last edited:

warren_s

Board Regular
Joined
May 28, 2007
Messages
73
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

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
you'll need to wait for someone else who will give you vba solution. I am away from vba, sorry
 

Watch MrExcel Video

Forum statistics

Threads
1,127,529
Messages
5,625,351
Members
416,096
Latest member
forevans

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top