Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Read/write text files

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - Read/write text files

Resolved · Low Priority · Version Standard

Reply Fri 16 Mar 2007, 16:21Delegate Lawrence said...

Lawrence has attended:
Excel VBA Intro Intermediate course

Read/write text files

How would I read or write from a text file (without importing into a worksheet)?

For upcoming training course dates see: Pricing & availability

Reply Thu 5 Apr 2007, 09:52Trainer Garry said...

RE: Read/write text files

You would open up the text file in the normal way outside of excel

VBA articles

· Company Roles in Visual Basic Training
· OOPS Visual Basic Did It Again
· VBA With Excel - Making The Working Day That Little Bit Easier
· Why Use VBA In The Office 2010 Suite?
· Should You Send Managers To VBA Training?

Vba tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips