Hi all,
I need some help writing this vbs script. After it's written, I will set up a Windows scheduled task to kick it off a couple of days a week. This is what I am trying to accomplish. Any help is greatly appreciated!
Open filename.xlsx file
Delete rows 1-4 and 6
Add new column named BRG between cols A and B
(Row 1 is now the header)
Delete cols E thru H
Loop:
Read value in cell (Row,1) in .xlsx file
Open brg.txt file
Look for the same value in the .txt file.
Chars 1-6 of each line.
If found, write value to .xlsx file cell (Row,2)
Otherwise write spaces to .xlsx file cell (Row,2)
Row = Row+1
Goto :Loop
Save as newfile.xlsx
I need some help writing this vbs script. After it's written, I will set up a Windows scheduled task to kick it off a couple of days a week. This is what I am trying to accomplish. Any help is greatly appreciated!
Open filename.xlsx file
Delete rows 1-4 and 6
Add new column named BRG between cols A and B
(Row 1 is now the header)
Delete cols E thru H
Loop:
Read value in cell (Row,1) in .xlsx file
Open brg.txt file
Look for the same value in the .txt file.
Chars 1-6 of each line.
If found, write value to .xlsx file cell (Row,2)
Otherwise write spaces to .xlsx file cell (Row,2)
Row = Row+1
Goto :Loop
Save as newfile.xlsx
Last edited: