Hi Experts. Let me apologize in advance for my ignorance as I do not know much vbscript.
Here is what I am looking for help on. I need a vbscript that will import the contents of a csv file, into a specific worksheet, in a predefined excel file. Then it needs to save as a tab delimited file.
The csv file and the predefined excel file is attached.
This is what I currently do and I am trying to automate the process.
1. I receive a csv file from vender (attached called "FileReceived")
2. I copy the contents into the "DAX Depts File" tab of predefined excel file (attached as "PredefinedFile")
3. Then I save just the first tab "DAX Miscellaneous Load File" as a tab delimited file (text)
My goal is to automate this process using vbscript by simply importing the contents into one tab and saving the other tab as a text file. Is this possible?