I have a textfile "engdata.txt" that i use in excel vba to take the values from cells and throw them into this CSV file.
Open "c:\path\engdata.txt" for append as #1
Write #1 Range("b8"
, Range("b9", etc...Close #1
How can I change the code so that I can test the variable B8 against the Range("B8"
in the current workbook before saving to see if it already exists and if so update that line of code with the info from the current worksheet.Your comments are greatly appreciated...