vba courses london - Read/write text files

Resolved · Low Priority · Version Standard

Fri 16 Mar 2007, 16:21 Delegate 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)?

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

RE: Read/write text files

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips