Bill Hamilton
Board Regular
- Joined
- Mar 30, 2004
- Messages
- 93
I have an Excel VBA project which needs to extract some info from a table in a Word document. I can open the Word doc ok, but how can I access the table? It's a one-row table with ten cells across, and I want to 'tab' along it extracting the value of each cell.
Problem is the Excel VBA doesn't seem to have the instructions for it. It doesn't understand the Word VBA instructions for doing that (eg Selection.MoveRight Unit:=wdCell) In fact anything I try to select from the table using the references to the Word doc which are set up when it is opened actually give me data from the currently active Excel sheet .
An alternative might be to copy the whole table and paste it into a spare place in my Excel workbook somewhere and analyse it there.
Is there any way of doing either of these things? I realise this is an "Excel" forum, but I'm sure there are experts on here who know about these things.
Problem is the Excel VBA doesn't seem to have the instructions for it. It doesn't understand the Word VBA instructions for doing that (eg Selection.MoveRight Unit:=wdCell) In fact anything I try to select from the table using the references to the Word doc which are set up when it is opened actually give me data from the currently active Excel sheet .
An alternative might be to copy the whole table and paste it into a spare place in my Excel workbook somewhere and analyse it there.
Is there any way of doing either of these things? I realise this is an "Excel" forum, but I'm sure there are experts on here who know about these things.