All, I have an excel spreadsheet

[tearsmith]

All,

I have an excel spreadsheet that I want to drop a table from word into. I have tried the copy/paste record macro thing, but it doesn't get that I have gone out of excel and come back in. Someone said that since my text in word is in a table, I have to use a "looping array". Huh??? I have 4 books on VB and none of them tell me how to write code to go to Word, pick up a table, and paste into Sheet1, cell A1 in Excel. Has anyone done this that can share code with me?

Thanks.

 

[Dashley]

tearsmith,

You wont find what you want in a VB book. Your going to have to look at "VBA Word" or "VBA Excell". I'm sorry I dont have any samples for you. I never tried what you attempting. I do know that you can create the excell object, read and store arange of cell values, open a word doc as an object put a cell/table into it and write your data to it.

dashley