formatting large batch of files

[Gerry Rigney]

Hi all, this is not strictly an excel setup question but I
dont' see any other excel sections. I'll pick your brains
any way:

I've a folder with about 100 subfolders all containing
around 10 .csv files. I need to format all these files
using the same formatting (remove some lines, distribute
some text to differnt columns etc) Question:

Is there any way I can for example set up a macro to do the
formatting I need but then automatically make it run
through all the csv file in the folder structure ?

I look forwart to any responses and appreciate any advice
on the topic.

Cheers
Gerry R

 

[Nick Hodge]

Gerry

A good starting point would be to record the settings you need using the
macro recorder. The next bit would need to be coded manually, but it would
be fairly simple using VBA's Dir Function and a variable to accept the file
name, etc.

Without much more detail it's hard to help more

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)