vba courses london - Extracting information from text files into excel with vba

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Extracting information from text files into excel with vba

Marie has attended:
Excel VBA course

by - delegate Marie [3 posts] (2007 Feb 22 Thu, 09:52) Reply

After my 2 day course of vba with excel, where do i go to learn how to use this to extract information from a large text file? (too large to import into excel)

RE: extracting information from text files into excel with vba

by - trainer Jacob gold contributer [106 posts] (2007 Mar 5 Mon, 12:11) Reply

Hi Marie

This sounds like a bespoke requirement. We need to see an example of the file(s) you are working with before being able to suggest the next steps forward.

It is reasonable to assume that this sort of requirement will involve a trainer working directly with yourself or on the files.

If you are interested in pursuing these options further please let us know.

Regards

Jacob

· Company Roles in Visual Basic Training
· Should You Send Managers To VBA Training?
· Visual Basic Returns To The Macintosh
· Introduction to Visual Basic for Applications
· How To Find A Good VB For Access Trainer

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