SteveG
09-20-2007, 08:49 AM
Hi all,
I have a .txt file that is scheduled to run daily (business days only). The file is saved using the report run date as the name. What I would like is to have excel import this file ("," delimited) automatically without human intervention each morning at the same time. The file would be imported to a specific tab (Current_Month_Data) in the workbook and overwrite the previous days import, calculate the workbook and save the changes turning the auto calc off. The workbook is huge with a lot of calculations that by month's end takes 30 minutes + to calculate and I am attempting to automate the manual processes so when I get in in the morning the report is complete. I would also like to have the code run at a specific time each morning. Is this possible?
Thanks in advance for your assistance.
SteveG
I have a .txt file that is scheduled to run daily (business days only). The file is saved using the report run date as the name. What I would like is to have excel import this file ("," delimited) automatically without human intervention each morning at the same time. The file would be imported to a specific tab (Current_Month_Data) in the workbook and overwrite the previous days import, calculate the workbook and save the changes turning the auto calc off. The workbook is huge with a lot of calculations that by month's end takes 30 minutes + to calculate and I am attempting to automate the manual processes so when I get in in the morning the report is complete. I would also like to have the code run at a specific time each morning. Is this possible?
Thanks in advance for your assistance.
SteveG