N
NateLake
I have a word document with an embedded EXCEL spreadsheet. I would like to
convert the visible EXCEL range and paste it back as a table in Microsoft
word. If I try to Open the excel sheet in an EXCEL application window, I
can't guaranteed that the sheet itself will display the corresponding area
shown in my word document (the sheet can have other ranges that I do not wish
to transform). My question is how do I select only the area of the sheet
that is displayed in the OLE picture in Microsoft Word. Any technolology
will do, however does anyone know of how (or if its possible) to accomplish
this using an VBA Macro in Microsoft word.
convert the visible EXCEL range and paste it back as a table in Microsoft
word. If I try to Open the excel sheet in an EXCEL application window, I
can't guaranteed that the sheet itself will display the corresponding area
shown in my word document (the sheet can have other ranges that I do not wish
to transform). My question is how do I select only the area of the sheet
that is displayed in the OLE picture in Microsoft Word. Any technolology
will do, however does anyone know of how (or if its possible) to accomplish
this using an VBA Macro in Microsoft word.