JackkG
06-18-2015, 03:31 PM
Hi All,
I need someone to help me with the automation here.
I got daily data files stored in "D:\DailyDataBack" folder, daily excel files are named according to dates, for eg. dailydata06192015.xlsm. I got almost 50+ such files in that folder and many more other files not starting with name "dailydata".
I want to cycle through each and every excel file in that folder that begins with file name "dailydata" and in every excel file in its second sheet/tab named "RiskReport", I want to save this as tab-delimited text file with the same name as "dailydata" excel file.
Can anyone help me out in this one?
Thanks!
cross-posted here:
http://www.excelforum.com/excel-programming-vba-macros/1089088-how-to-save-the-sheet-in-text-file-through-vba.html#post4106737
I need someone to help me with the automation here.
I got daily data files stored in "D:\DailyDataBack" folder, daily excel files are named according to dates, for eg. dailydata06192015.xlsm. I got almost 50+ such files in that folder and many more other files not starting with name "dailydata".
I want to cycle through each and every excel file in that folder that begins with file name "dailydata" and in every excel file in its second sheet/tab named "RiskReport", I want to save this as tab-delimited text file with the same name as "dailydata" excel file.
Can anyone help me out in this one?
Thanks!
cross-posted here:
http://www.excelforum.com/excel-programming-vba-macros/1089088-how-to-save-the-sheet-in-text-file-through-vba.html#post4106737