MPW
Well-known Member
- Joined
- Oct 7, 2009
- Messages
- 571
- Office Version
- 365
- Platform
- Windows
I am looping through a folder of .usx files to modify the content. I thought the easiest would be to load it into a workbook, modify it and then create a new .usx file from the content.
Here is the method of export:
This all works well, however there are additional quote marks added in the process. Hopefully my picture is worth a thousand words... Now I know I can replace these errors in word or notepad, but since I am working through many files it would be nice if it could be added to the automated process. If you need more info let me know. Thanks
Here is the method of export:
VBA Code:
wb.SaveAs Filename:=sbf & "\" & oFile.Name, FileFormat:=xlCurrentPlatformText