Export to XML map on 64-bit Win 7

A-ha. It looks like the modifications re PtrSafe/LongPtr did do the trick after all :-) I thought the add-in had failed to install because the 'Source' and 'Import' buttons in the Developer/XML menu were disabled - but it turns out there was something in the particular worksheet I had open that was causing that. When I created a new worksheet those buttons became enabled - and when I copied and pasted by data in to place they remained active so I was able to do the export. Happy days.

Kevin.

Hello Kevin,

I would appreciate if you could kindly post the changes you made - you stated that you used PtrSafe and LongPtr as described at http://msdn.microsoft.com/en-us/library/ee691831.aspx

But when I tried it I could not get it to work - XML map do not appear in XML Source when I convert a range to a XML list.

Only change I made was for the 1st line

Private Declare PtrSafe Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (ByVal nBufferLength As LongPtr, ByVal lpBuffer As String) As LongPtr


Thanks in advance


Andrew

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.