J
Jim
Hello,
I have to work with word (2003) documents in which are embedded (I believe
that is the right term) a number of excel tables.
I need to be able to extract info from each of the tables, with the
information in the excel tables, in named ranges ( 1 cell each name) to use
in the Word document.
If possible, I would probably like to be able to edit the text within the
cells as well, or even add/delete rows and columns with vba programs that I
have already for the current version of the report which uses word tables
in a word document. Why they decided to change is beyond me.
How do I programatically identify, access and perhaps alter the excel
tables from word. As far as I can tell, the tables are not identifed by
names/bookmarks, and they are not liked to any actice excel files either as
I am working on a different computer than that which makes the files
initially (not on a network etc).
I am ok at VBA but can't find out how to accomplish this by using the help
files.
Thank you .
Jim
(e-mail address removed)
I have to work with word (2003) documents in which are embedded (I believe
that is the right term) a number of excel tables.
I need to be able to extract info from each of the tables, with the
information in the excel tables, in named ranges ( 1 cell each name) to use
in the Word document.
If possible, I would probably like to be able to edit the text within the
cells as well, or even add/delete rows and columns with vba programs that I
have already for the current version of the report which uses word tables
in a word document. Why they decided to change is beyond me.
How do I programatically identify, access and perhaps alter the excel
tables from word. As far as I can tell, the tables are not identifed by
names/bookmarks, and they are not liked to any actice excel files either as
I am working on a different computer than that which makes the files
initially (not on a network etc).
I am ok at VBA but can't find out how to accomplish this by using the help
files.
Thank you .
Jim
(e-mail address removed)