LinkBack URL
About LinkBacks
I am trying to convert ~200 xlsx files in a directory to txt using vb. Is the below attempt close or what is the best way? Thank you.
VB
or maybe:
Please Login or Register to view this content.
Please Login or Register to view this content.
I am trying to convert ~200 xlsx files in a directory to txt using vb. Is the below attempt close or what is the best way? Thank you
VB
or maybe:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by cmccabe; 12-28-2015 at 05:12 PM. Reason: added code
That will get your txt file set up, but does nothing to the old xlsx file. If you do not want to keep the old xlsx file you would need to include a delete statement for it.
I am trying to convert each xlsx to a txt in the directory without deleting the original, but the syntax is not correct. Thank you
VB
The second VB runs but no output results.Please Login or Register to view this content.
Last edited by cmccabe; 12-28-2015 at 05:49 PM. Reason: added details
Something like this, maybe. Not sure about the directory, don't know where the original file is stored.
Please Login or Register to view this content.
The directory is correct. I think my problem will be I need to copy all workbooks in those .xlsx with the word
analysis in them. Each xlsx file contains multiple workbooks, but the "analysis" workbook is the only one needed. Thank you very much
You know how to use the * wild card in the Dir function I hope. If analysis comes first "analysis*.xlsx", if it is embeded between "*analysis*.xlsx", if trailing "*analysis.xlsx" and hopefully it is consistent in all files.
You're welcome,
Regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks