leknowlton
New Member
- Joined
- Nov 18, 2012
- Messages
- 2
Hello,
I'm wondering how I can convert multiple delimited text files selected from a dialog to xlsx using vba. I have used the select dialog before in a macro, but only for a single file. I know how to set the multiselect option. The question really is how can I get vba to convert all of the selected files to xlsx. A loop? Is there an array accessible from having selected the files? Any assistance would be greatly appreciated! Thank you!
Larry
I'm wondering how I can convert multiple delimited text files selected from a dialog to xlsx using vba. I have used the select dialog before in a macro, but only for a single file. I know how to set the multiselect option. The question really is how can I get vba to convert all of the selected files to xlsx. A loop? Is there an array accessible from having selected the files? Any assistance would be greatly appreciated! Thank you!
Larry
Last edited:
