Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.tables,microsoft.public.word.vba.general
|
|||
|
|||
![]()
Hi-
I am working remotely in word vba through excel vba. Basically I have programed in excel to create a new word document, add a button, and then add code to the word document for when the button in excel is clicked. The code I am adding to the word document needs to copy a table and paste it (right above the button). I figured out how to copy a table if you give it an index number, but with the other code I am running the number of tables always changes. Therefore hardcoding an index number is a bad idea. I will end up copying different tables each time and not the one I want. Is it possible to add a name or range to that table, so I can just copy the table name or range? If this is not possible, I wanted to know if its possible to code adding an excel reference library in word. If I have the word document button code remote access excel to get the named table range that way, I need to figure out how to code an excel reference library into the button code. I do not know how or if this is possible. Manually setting it is not an option. I really hope someone can help me! Thank you so much in advance. sarah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
Problems printing a word document with linked excel tables. | Excel Discussion (Misc queries) | |||
Copy Word tables to Excel | Excel Discussion (Misc queries) | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) |