I seek assistance on how I can convert 3 notepad files (.txt) to 3 sheets of one Excel workbook entitled Feeders_CurrentDate.xlsx (Current_Date being the day's date).
Firstly I want to move the attached 3 files from my hard drive to a specified folder then convert these to one excel workbook:
feeder3_statistics_20110821
feeder4_statistics_20110821
feeder5_statistics_20110821
File name has its current date (Format: yyyymmdd) so the file name varies each day and data comes from 3 sources namely Feeder3, Feeder4 and Feeder5.
Data should have headers in Excel and columns are marked by spaces (25 columns and 24 rows). Each sheet should have the name of the original notepad file
Firstly I want to move the attached 3 files from my hard drive to a specified folder then convert these to one excel workbook:
feeder3_statistics_20110821
feeder4_statistics_20110821
feeder5_statistics_20110821
File name has its current date (Format: yyyymmdd) so the file name varies each day and data comes from 3 sources namely Feeder3, Feeder4 and Feeder5.
Data should have headers in Excel and columns are marked by spaces (25 columns and 24 rows). Each sheet should have the name of the original notepad file
