VBA (access) and Autocad layouts

Hi,
I want to extract the names of the layouts in a given ACAD '.DWG) file.
Purpose is to check if all PDF's correspond with a layout. If the Layout does not exist any more, we have to delete the PDF version so everything stays synchronised.

My question : how do I find the layouts in an DWG-file, with code in VBA, and extract the names of the layouts?

thanks for any tips, tricks, links and so on !!!

Bob

if your department is being constantly given updates of latest ISO drawing (revisions), then you would not need any vba.