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

Need to limit the size of a text file being written too by excel

Status
Not open for further replies.
LSIGuy

LSIGuy

MIS
Jun 26, 2002
18
US
Hello,

I am using a notepad txt file to dump log info from my VBA program. I am using the Append method to tag new info onto the bottom. Now, it is getting really big! (As I'm sure you can imagine...) Is there any way that I can tell VBA to start deleting stuff from the top once it gets to a certain size? This would really help me out!!!

Thanks,
LSIGuy
 
Status
Not open for further replies.

Similar threads

feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
985
SkipVought
S
Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
3K
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
918
mintjulep
M
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
972
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top