Modify Batch Conversion Wizard Code

[Dave A.]

Does anyone have any sample code to automate the Batch
Conversion Wizard so the user only has to click on the
template word file and it automatically goes to a hard
coded folder and converts all the text documents into the
second hard coded folder without the user being prompted
for anything.
I eventually want this file to run by itself every
mourning without any user interaction.

thanks
Dave A.

 

[Jonathan West]

Does anyone have any sample code to automate the Batch
Conversion Wizard so the user only has to click on the
template word file and it automatically goes to a hard
coded folder and converts all the text documents into the
second hard coded folder without the user being prompted
for anything.
I eventually want this file to run by itself every
mourning without any user interaction.

That's not hard code to write.

This article gets you part of the way there.

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

What you need to do to that is remove the find/replace code from the inside
of teh loop, and replace it with your own "Save As" code pointing to the
destination folder.

 

[Guest]

-----Original Message-----




That's not hard code to write.

This article gets you part of the way there.

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

What you need to do to that is remove the find/replace code from the inside
of teh loop, and replace it with your own "Save As" code pointing to the
destination folder.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

.

Would it be best to execute my code in Hostscript
(vbscript) and schedule a task to execute this file each
mourning or keep it in a word doc and have the task
scheduler execute the word doc with an imbedded macro to
format the text and page layout. Some of the commands/code
don't translate the same from vba to vbscript.
Thanks,
Dave

 

[Jonathan West]

I'd suggest that you put the code into a macro in a template, maybe call it
BatchRun or something. Test it thoroughly and make sure it does what you
want.

Then create a VBScript that starts an instanmce of Word, opens the template
and then runs the batchRun macro using the Run method of the Word
application.

Once you have that working, you can put the VBScript into the scheduler.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup