Sandra Frongillo
asked on
Macro to open a .txt file and save as an .xlsx file
I need a macro that will go to a spceified file location in excel (located in cell a1) that will search all subfolders within that path, look for a *_*.txt file and it will open the text file, save it as an .xlsx file, remove the underscore from the name and tack on a date (located in cell a2 ('11-02-2011). Is that possible? Thanks!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.