VBA icon

Find and replace in text files

binoculars

Replacing text inside text files doesn't mean you need to open them or paste them into Excel. We can do everything strictly in VBA.

Continue Reading: Find and replace in text files »

Excel icon

Conditional Import Text Files

If you have a text file to import, but only need some of the data, you could just import the whole thing and then manually scrub the data to find what you want. Text files can contain a lot more lines than an Excel worksheet, but much of it may be fluff. Here's a method for importing only the data you need.

Continue Reading: Conditional Import Text Files »

Site last updated: February 9, 2012