Forum Discussion
using Open File dialog in VBA
I am using vba code in MS Word [Office365]. When I display the Open File dialog for the user to select multiple files, it is not allowing me to select files from multiple folders.. I can however se...
In my tests, it is NOT possible to manually select files from multiple folders. So, not surprising that it cannot be done with code.
What were you wanting to be done with the files?
What were you wanting to be done with the files?
Thanks for your response Doug. I was helping my daughter to automate creating headers for about 150 Word documents. I am creating a list of files in a listbox and then process them one at a time.
Maybe, I should let her select files in a folder, save them and then let her go to another folder and select more files. When she is all done, I can start processing. I recently retired after 46 years of IT and getting back to programming to keep myself busy. I am sure I will be facing challenges but at the same time learning new stuff. THANKS again for your response.
Maybe, I should let her select files in a folder, save them and then let her go to another folder and select more files. When she is all done, I can start processing. I recently retired after 46 years of IT and getting back to programming to keep myself busy. I am sure I will be facing challenges but at the same time learning new stuff. THANKS again for your response.
- The best thing to do is copy all of the files that are to be processed into a separate folder and you can then use a batch process to modify all of the file in that folder.
See the following page of Graham Mayor's website:
http://www.gmayor.com/document_batch_processes.htm