Extracting an Excel Table from word programmatically.

[Joseph P.]

I have a Word document with an embedded Excel table. I need to
programmatically extract this table into a new spreadsheet or Access DB.

 

[Kevin B]

If you're going to be using Access you can either import the Excel file
directly, or link to it as a data source. That would be the simplest
approach.

 

[Joseph P.]

Here is the deal.

Customers are sent quote sheets and are asked the fill out the purchase
order via an embedded Excel table. The are then sent back the salesmen.
This solution 'attempt' will save the salesmen from having the open every
sales sheet that come through. The table is embedded in word and filenames
can different.

 

[Cindy M -WordMVP-]

Hi Joseph,

Customers are sent quote sheets and are asked the fill out the purchase
order via an embedded Excel table. The are then sent back the salesmen.
This solution 'attempt' will save the salesmen from having the open every
sales sheet that come through. The table is embedded in word and filenames
can different.

Which version of Word/Office do you have?

There is no way to extract the data from the embedded worksheet without
actually opening the document in Word. This can be done using automation (all
files in a particular directory, for example). Is that the kind of thing
you're looking for?

How much programming experience do you have, in any kind of programming
language (which one(s))?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Joseph P.]

I would like to do this with Office 2003 Suite.

I was hoping to use automation in that I would create a VB application that
would create an instance of a word document and load the quote document into
the object. After that, based on what I read in other post, I wanted to
created an instance on an excel object and link it to the table embedded in
the word document.

If this needs to be done on an individual file basis, I am willing to create
a macro in VBA.

If it is easier, I could also do this in VB.Net though 6.0 is my preferance.

I can pick up languages very quickly so if it can be done with something
else please let me know.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Sm9zZXBoIFAu?=,

I'm still not certain I understand exactly what you're aiming for, but it's
certainly possible for you to do the following with VB6:

- automate the Word application
- create a document
- bring Excel data into the document as a table (either Word table or embedded
Excel table)
- create an embedded Excel workbook in the document and populate it

Which of the last two options did you have in mind?

I would like to do this with Office 2003 Suite.

I was hoping to use automation in that I would create a VB application that
would create an instance of a word document and load the quote document into
the object. After that, based on what I read in other post, I wanted to
created an instance on an excel object and link it to the table embedded in
the word document.

If this needs to be done on an individual file basis, I am willing to create
a macro in VBA.

If it is easier, I could also do this in VB.Net though 6.0 is my preferance.

I can pick up languages very quickly so if it can be done with something
else please let me know.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail