Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PUT # and Get #

Status
Not open for further replies.
buddyel

buddyel

MIS
Joined
Mar 3, 2002
Messages
279
Location
US

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...
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question Question
put value in input box web page
Replies
0
Views
401
2009luca
2009luca
Submeg
  • Locked
  • Question Question
Selecting shapes based on its name and then arranging them in a circle
Replies
2
Views
459
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question Question
Copy data between SQL and Oracle
Replies
8
Views
2K
remeng
remeng
Andrzejek
  • Locked
  • Question Question
Get sub-folders from FTP
Replies
4
Views
553
Andrzejek
Andrzejek
remeng
  • Locked
  • Question Question
Getting results from a dynamic dimension array
Replies
2
Views
888
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top