Hi Macropod,
Thank you for the small explanation on the error and on the code issue, it helps understand the problems. That code was copied and then modified from the link I provided. However this is the first time I've ever tried to create these types of documents in word and excel, and the first time I've attempted to create a macro like this. I am learning as I go.
As for the extraction, I only want to obtain this information from the one document at a time that I am currently filling out, not from multiple ones simultaneously. The register only needs to be updated as a corrective action is generated which can sometimes be weeks or months between each one. This is why I was looking for the word document driving the updating of the excel workbook.
With the Export_Click - If the macro is able to ensure only unique entries based on the CAR No. field, then a second click of the Export button would simply update the same row. Is this possible?
Cheers,
Seb
|