This is actually step 1 of a 2 step process but I will start a new thread for the next step and link if possible.
Currently I am dumping data from an AIX system flat file into a text file (*.prt). I'm able to successfully import the data manually using a fixed space delimited import method but too novice to set this up automatically. I imagine I'll set up a task to trigger a process for excel 2007 to open my excel workbook. Is there a way I can automate a macro to run each time this workbook file is opened? It should import the *.prt text based file using fixed space delimiters with spaces occurring at 3,18,30,53,64,75,76,79, & 84
The file will also be imported from a samba share but the drive is mapped locally.
Any help would be wonderful!
Thanks in advance
Seth
Bookmarks