Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2003

Tip: Looking for answers? Try searching our database.

formatting large batch of files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gerry Rigney - 21 Oct 2003 11:15 GMT
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 - 21 Oct 2003 21:46 GMT
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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@btinternet.com.ANDTHIS

> Hi all, this is not strictly an excel setup question but I
> dont' see any other excel sections.  I'll pick your brains
[quoted text clipped - 14 lines]
> Cheers
> Gerry R
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.