I want to create a Macro in Excel to open all the word files in a folder. And save in the same name with XML format in the same folder. Anybody can help me?
I want to create a Macro in Excel to open all the word files in a folder. And save in the same name with XML format in the same folder. Anybody can help me?
Hi Ravikd,Please Login or Register to view this content.
You may need to change the red code to the actual path nme but if you have an excel workbook in that folder then it will run if you have that file up and active
Last edited by xladept; 10-18-2014 at 06:45 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks