-
Apr 27th, 2021, 10:43 PM
#1
Thread Starter
New Member
Automate export of Excel file to XML file
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 :
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
-
Apr 28th, 2021, 09:45 AM
#2
Re: Automate export of Excel file to XML file
-
Apr 28th, 2021, 12:38 PM
#3
Thread Starter
New Member
Re: Automate export of Excel file to XML file
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.
-
Apr 28th, 2021, 01:20 PM
#4
Re: Automate export of Excel file to XML file
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|