J
Jim
Hello,
I have a word (2003) document that currently had Word tables, that my vba
macro extracts the data from and everything is just fine.
Well, the people who generate the word document are switching to excel
tables embedded (not linked) in the word document (actually, each is a
small worksheet).
Each word doc has 17 tables, and although I can refer to each as an
inlineshape(i), then activate it, I can't seem to access/retrieve the data
in the excel tables.
The data in the excel tables are in named ranges (1 datapoint to each
named cell) so if I could find a way to tell word vba how to look into the
embedded excel tables and assign the data in the named ranges to a word
variable , I would be fine.
I tried opening the excel tables in excel (acitvating the tables in word),
but then I have no idea how to tell the word vba macro to get the data and
close the table/worksheet.
Any help would be appreciated.
Jim
(e-mail address removed)
I have a word (2003) document that currently had Word tables, that my vba
macro extracts the data from and everything is just fine.
Well, the people who generate the word document are switching to excel
tables embedded (not linked) in the word document (actually, each is a
small worksheet).
Each word doc has 17 tables, and although I can refer to each as an
inlineshape(i), then activate it, I can't seem to access/retrieve the data
in the excel tables.
The data in the excel tables are in named ranges (1 datapoint to each
named cell) so if I could find a way to tell word vba how to look into the
embedded excel tables and assign the data in the named ranges to a word
variable , I would be fine.
I tried opening the excel tables in excel (acitvating the tables in word),
but then I have no idea how to tell the word vba macro to get the data and
close the table/worksheet.
Any help would be appreciated.
Jim
(e-mail address removed)