Hi,
I have lots of documents that I need to look through, and I need to find out if there are any 'HOLDS' (withheld information) in them.
In each document, there are several tables, one of which is the list of holds to do with that document. However, the format of each document is not the same and therefore the holds table can be in different places depending on the document.
I would like to automate the search process so the VBA code searches the tables in the document, and then once it finds ‘hold number’ in the column heading, it extracts that table to an access table for referencing. I have extremely limited VBA knowledge, as I have only worked with access SQL script writing, so comments through the script saying what is going on would be greatly appreciated.
Is this possible?
Thanks in advance
I have lots of documents that I need to look through, and I need to find out if there are any 'HOLDS' (withheld information) in them.
In each document, there are several tables, one of which is the list of holds to do with that document. However, the format of each document is not the same and therefore the holds table can be in different places depending on the document.
I would like to automate the search process so the VBA code searches the tables in the document, and then once it finds ‘hold number’ in the column heading, it extracts that table to an access table for referencing. I have extremely limited VBA knowledge, as I have only worked with access SQL script writing, so comments through the script saying what is going on would be greatly appreciated.
Is this possible?
Thanks in advance