Macro for selecting files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 12 Apr 2006 21:20 GMT

Hi,
I have a macrfo that will open a single word file, extract the data and save
it as a csv file - which is what I want. What I now need to do is to make
the macro do this automatically for every .doc file in the folder, and I
have no idea how to do this.

Is this possible and if so can some kind person point me in the right
direction

thanks
A

Reply to this Message

Jonathan West - 12 Apr 2006 21:46 GMT

> Hi,
> I have a macrfo that will open a single word file, extract the data and
[quoted text clipped - 4 lines]
> Is this possible and if so can some kind person point me in the right
> direction

You should be able to adapt this article to your needs

Find & ReplaceAll on a batch of documents in the same folder
http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Al - 12 Apr 2006 21:52 GMT

Thanks Jonathan exactly what was needed.

Cheers for the post

Alex

>> Hi,
>> I have a macrfo that will open a single word file, extract the data and
[quoted text clipped - 9 lines]
> Find & ReplaceAll on a batch of documents in the same folder
> http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

Reply to this Message

Rate this thread: