View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerry Rigney Gerry Rigney is offline
external usenet poster
 
Posts: 2
Default formating multiple excel .csv files ?

Hi all

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