 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / January 2006Extracting an Excel Table from word programmatically.
I have a Word document with an embedded Excel table. I need to programmatically extract this table into a new spreadsheet or Access DB. 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.  SignatureKevin Backmann > I have a Word document with an embedded Excel table. I need to > programmatically extract this table into a new spreadsheet or Access DB. 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. > 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. > > > I have a Word document with an embedded Excel table. I need to > > programmatically extract this table into a new spreadsheet or Access DB. 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))? > > 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. > > > I have a Word document with an embedded Excel table. I need to > > > programmatically extract this table into a new spreadsheet or Access DB. 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 :-) 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. > Hi Joseph, > [quoted text clipped - 27 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) 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. > [quoted text clipped - 33 lines] > > > > > I have a Word document with an embedded Excel table. I need to > > > > > programmatically extract this table into a new spreadsheet or Access DB. 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 :-)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.