Daily, I recieve a 3rd party XML file that I parse in Excel (using an excel macro) and then import into an Access database. Infrequently, the data will import into Excel, then parse and then the routine stops with the error message above. I look through the raw XML file and everything appears to be within the brackets, etc. Can someone give me some clarification to the meaning of the error message? Thanks in advance and Mery Christmas and Happy Holidays!
The error message might be generated within your macro - as it is parsing the data it might detect that some field which should be numeric will be interpreted by Excel as text, and it stops to warn you of this. Examine the last completed field in the Excel worksheet to see if this is the cause, and then relate it to the XML file. Hope this helps. Pete