I would like to know how to go about setting up an automatic text import into Excel on a weekly basis at a specific time unattended... if that is possible.
The text file is pipe delimited.
I run the report weekly, download to my desktop then import into Excel. I can set the report to run and download automatically but them need the second part to initiate and import into Excel and save that file with a specific name and the date run.
So... whadya think?
The text file is pipe delimited.
I run the report weekly, download to my desktop then import into Excel. I can set the report to run and download automatically but them need the second part to initiate and import into Excel and save that file with a specific name and the date run.
So... whadya think?