If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formatting large batch of files
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 |
Thread Tools | |
Display Modes | |
|
|