Formatting a word document using vbscript 1

[mdalin]

Hi!

I'd like to get data from one excel sheet and then create a word document with some of that data. I'd also like to format this word document with different types of fonts, sizes etc. Is this possible using vbscript (WSH), or are there any better solutions? If it is possible, where can i find information about functions to use on a word document?

Thanks a lot
/Mathias

 

[KarMac21]

I would personally use VBA instead of VBScript to accomplish this task. I think the easiest way to do this would be to create a word template and then within Excel write the code to populate the fields you have setup within the Word template.

Shane

 

[dougcranston]

You can create Word in VBScript.

Finding information is sketchy at best on how to do it.

I am working on a script to take data out of Access 97 Db and create a "phone directory" in Word, creating tables.

Has been a pain, but fun.

Some pages to get some information include:
tek-tips FAQ329-299 and FAQ329-670(VBScript faq)

Create Word on the Server

http://www.codeave.com/asp/print/asp?u

log=142

Create and email a word doc from ASP

http://wwww.freecode.com/Showcode.asp?ID=1727

Try searching for some form of:
Creating a word document from ASP

Realistically, I have found little detailed documentation.

Doable, but you have to ferret out the pieces in VBA and then look at the Object Browser and look at the methods/properties etc.

Best sample, albeit based on VBA is

http://www.helenfeddema.com

Look at her Access Archon Columns. A number of them involve Word and Access and ADO and Excel. Has helped on some points.

Hope this helps.