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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel data to txt 1

Status
Not open for further replies.
bobibob

bobibob

Technical User
Jun 28, 2001
13
SI
Hi!

I have one txt file and I would like to write a macro which would add some cell values from excel to the end of this file.

Does anyone have any idea?

Thanks
 
Sort by date Sort by votes
Something like the following sequence would work:

open "MyFile.txt" for append as #1
print#1,range("thisvalue"),range("thatvalue")
close#1

Rob
[flowerface]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
564
remeng
remeng
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
199
strongm
strongm
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
380
strongm
strongm
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
338
huiettcm
huiettcm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
297
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top