script to copy spreadsheet into MS Word?

[itpmguy]

Hi,

Is there any way I can copy data from all the sheets of a spredsheet and put it into a Microsoft Word document in a table format? It should name the Word doc table name as the name of the corresponding sheet in spreadsheet. If there is already a script for this, then please send me the link.

Any help is appreciated.

Thanks


Cheap Computer Part Supply Buying Tips

http://www.cheap-computer-part-supply.com

VOIP Phone Service Guide

http://www.ez-voip-phone-service.com

 

[markdmac]

Use the macro editor to record the steps in each program and you should be able to piece them together into a single VBScript.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript