I have need to export Excel spreadsheets to XML.  To do this previously, I found that Microsoft provides "Excel 2003 XML Tools Add-In" . 

I've used this add-in previously with great success with Excel 2010, 32-bit.  I now have a new computer with 64-bit Excel 2010 installed.  When I tried to load this add-in, I'm getting the following error:

"Compile error:

The code in this project must be updated for use in 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute."

Any assistance would be greatly appreciated.

Thank you.

--James--

Hi James,

If you only need to export Excel spreadsheets to XML in Excel 2010, how about using Save as... --> XML Data (*.xml) instead?

To use the add-ins created for 32-bit version of Office, either consider using the 32-bit version of Office 2010, or converting the code to 64-bit by follow the instructions in this MSDN srupport article http://msdn.microsoft.com/en-us/library/ee691831.aspx

To find help on converting the code, you can visit http://social.msdn.microsoft.com/Forums/en-US/exceldev/threa

Thank you for the information.  I really appreciate you taking the time to try to help.

1. I tried to save as XML.  Unfortunately, Excel is complaining that there are no XML mappings.  I will try to track down how to get that to work, but it seems like it will be a manual process each time I have a new spreadsheet to process.
2. I am using a new computer, which came pre-installed with the Office suite.  Evidently, the company opted to install the 64-bit version.  I don't know that I have an option to run the 32-bit version (though I would if it was an option for me).
3. I was figuring to try to get the add-in to work under 64-bit, but was struggling to make any headway.  Thanks for the pointer to the ExcelDev forum.

2. I am using a new computer, which came pre-installed with the Office suite.  Evidently, the company opted to install the 64-bit version.  I don't know that I have an option to run the 32-bit version (though I would if it was an option for me).

Sorry that we couldn't install 32-bit version of Office together with the 64-bit version of Office. That means, to use 32-bit version of Office applications, we need to remove the 64-bit version of Office instead.

BTW, in most case, 32-bit version of Office is recommanded even on a 64-bit version operating system. See http://office.microsoft.com/en-us/support/choose-the-32-bit-or-64-bit-version-of-office-HA102840825.aspx

Since your Office is preinstalled, I'd suggest you to contact the computer manufactory for infomation about how to reinstall the preinstalled products, such as how to get the install media (maybe they could be included in the package which has delivered along with the computer).

Now it's 2015 and 32-bit operating systems and applications are a thing of the past.  Yet this appears to still be the best advice Microsoft can provide to export XML simply from an Excel spreadsheet.  Apparently we have three options:

1) Figure out how to create an XML mapping for our spreadsheet;

2) Fix the VBA in the original Excel 2003 XML add-on to work on a 64-bit machine;

3) Export the spreadsheet to Access then use Access to export it as XML.

So it would appear Microsoft have had an issue with exporting XML from Excel for at least 12 years (since the original add-on for Excel 2003 was obviously created to fill a hole in Excel 2003's functionality).  And the options above are the best Microsoft can come up with.  Why not Save As... XML and just, you know, save it as XML?  Without need for mappings or anything?  It's obviously not impossible as other Microsoft products can do it.