converting tabular structures in a Word document into an actual table or reading data from the tabul

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-06-02T15:41:56Z Indexed on 2010/06/02 15:44 UTC
Read the original article Hit count: 187

Filed under:

access-vba

I have a macro which can read the last cell/column of all tables in a Word 2003/2007 document and store the data in an MS-Access table. But, some Word documents have the data in structures like a table format but are not actually tables. The structure looks like a table, but the table borders are actually line connectors. These documents were created by a software(VeryPDF PDF to Word converter) which converted the PDF documents(the original format these documents were) into Word documents.

Is there a way I can convert/replace the tabular structures with actual tables in Word so that I can use the macro?
Or, is there a way I can read the value of the last column from the tabular structures using some VBA code?

Any advice would be appreciated.

Related posts about access-vba

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Access VBA sub with form as parameter doesn't alter the form

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Microsoft Access 2003 file with various tables of data. Each table also has a duplicate of it, with the name '[original table name]_working'. Depending on the user's choices in the switchboard, the form the user choose to view must switch its recordsource table to the working table. I… >>> More
Achieve Rails-style migrations in MS Access VBA application

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a simple way to do Rails-style migrations in a VBA application. Just add additional migrations like migration(name, sql_string, database) to run_migratons and call run_migrations somewhere in the beginning of your execution. Function migrate(signature As String, sql As String, dbs As DAO… >>> More
Using INSERT INTO and setting one field value - Access VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using INSERT INTO to copy rows of data from one table to another: INSERT INTO tblNewCustomers (CustomerID, [Last Name], [First Name]) SELECT CustomerID, [Last Name], [First Name] FROM tblOldCustomers How can I set one of the field values in tblNewCustomers for all of the new records that… >>> More
MS-Access VBA: form_error vs on error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to set up error handling for a MS-Access application. The standard method to do this seems to be with an On Error statement in each subroutine/function. It seems simpler to me to use the Form_Error function to catch all the runtime errors in that form as opposed to an On Error statement… >>> More

Developer IT