Automate export of Excel file to XML file

[aminedz]

Hi all,
I have about 200 xlsx files that are exportable to XML.
So I want to automate the process of export (not conversion but export).

Here is a pseudo code :

For each xlsx file
begin
	open file with Excel
	go to developper tab
	export to XML
	set xmlFilename
	save xmlFilename
end

How can I do that ?

Thanks in advance

[Peter Swinkels]

Hi, aminedz. Welcome to the forum.

To get a list if your xlsx files in a directory: https://devblogs.microsoft.com/scrip...ts-subfolders/. To open a workbook: https://docs.microsoft.com/en-us/off...workbooks.open. To save a workbook: https://docs.microsoft.com/en-us/off...orkbook.saveas. To find the right value to use with the SaveAs method: https://docs.microsoft.com/en-us/off...l.xlfileformat.

[aminedz]

Hi Peter, Thanks for your reply.
Thanks also for the tips you gave me, but actually, there's a problem on how to export to xml.

Here is an example of an xlsx file that can be exported to XML.

The question is : how to implement, with the "export" feature on the Developer Tab in Excel.

The export feature is not a SaveAs method.

Thanks in advance Peter.

[Peter Swinkels]

I am sorry, I misunderstood your question. Does https://docs.microsoft.com/en-us/off...lmap.exportxml help?

Oh, and this doesn't appear to be a vbscript question. I believe you need this forum: https://www.vbforums.com/forumdispla...ce-Development.