Thanks for responding! It is between 2 different proprietary software to transmit data, one way. I have 2 files from the data source software explaining what is needed. How can I get them to you?
File ID: 186974 and File ID: 983854
Steps required for the macro to perform: (this should be a new excel file (xls) that will contain a macro which will perform these functions)
When the macro is launched it should open the “NvisImport.csv” file (template)
It would then find the “nvis.txt” file and automatically input the data starting at the 2nd row.
Once it’s completed, ideally it would then save the file as a new csv file name (maybe default to the current date it was created: 060115.csv)
Then it should exit the macro
The customer would then log on to the server and upload the file to system.
What is the issue?
Hi, See the link below for the workbook and macro you requested. Since the template and the data files location may vary I added 3 buttons.
1. Select Template(your NvisImport.csv file)
2. Select Folder where you would like to export the data files to
3. Generate file...This will also prompt to select your text file (Nvis.txt)
The result will be files placed in the folder you select in step 2 above with the following naming convention(20150605_Nvis.csv, where 20150605 is the date) Note: in order to avoid accidentally overwriting a file on the same date the macro will add v_2, v_3 to the end of the file name.
Please Let me know of any changes or corrections you may need. It is my pleasure to assist. Download Link: http://wikisend.com/download/170406/AppendTextFile.xls