Link to home
Start Free TrialLog in
Avatar of Sandra Frongillo
Sandra FrongilloFlag for United States of America

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
Avatar of m_travis
m_travis
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial