I've written my first VBA macro to export data from XLS to a named XML file. My initial, simplified tests went fine but the full version errors with the message:
Run-time error '-2147024809 (80070057)':
The parameter is incorrect
and the line 'doc.Save sFile' is highlighted.
Can anyone help?
NOTE: I had to post the code as a Word file attachment because the site thinks it contains HTML.
Sub OrdXMLExport.docx
Bookmarks