Tag Archives: Import large files

Daily Download 32: Text functions

Posted on 20/10/2012 by dougaj4

Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

Importing text files with VBA – 3

Posted on 27/06/2008 by dougaj4

The text import file has been modified to split large files into one or more ranges. The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the … Continue reading →

Posted in Excel, UDFs | Tagged , , , , , | 20 Comments