Hi,
I want to take a macro that I have "to the next level". We have some measurement equipment that exports data collected as a .txt file into a folder. When the next test is performed, a second text file is placed in the same folder.
The problem is, the text files just contain the test data. What I want to do is have information in my spreadsheet starting in cell C5 down to cell C13 copied and pasted into each text file in the folder.
Specifically I would like for it to work like this:
Open text file
Delete the very first line of the text file
Copy cell C5 in the very first line
Copy cell C6 in the next line
Continue to cell C13
Loop through all of the *txt files in the folder
The delete the very first line in the text file is important...
FYI The cells in the spreadsheet - I'm want to have the part name, type of test, name of the tester, etc.
The idea is when those parameters change I just update the spreadsheet, run the macro, and I have updated text files.
Thank you in advance for your help
I want to take a macro that I have "to the next level". We have some measurement equipment that exports data collected as a .txt file into a folder. When the next test is performed, a second text file is placed in the same folder.
The problem is, the text files just contain the test data. What I want to do is have information in my spreadsheet starting in cell C5 down to cell C13 copied and pasted into each text file in the folder.
Specifically I would like for it to work like this:
Open text file
Delete the very first line of the text file
Copy cell C5 in the very first line
Copy cell C6 in the next line
Continue to cell C13
Loop through all of the *txt files in the folder
The delete the very first line in the text file is important...
FYI The cells in the spreadsheet - I'm want to have the part name, type of test, name of the tester, etc.
The idea is when those parameters change I just update the spreadsheet, run the macro, and I have updated text files.
Thank you in advance for your help