I have a frustrating issue where VBA is not reading the reference file offset correctly. I'm working with a bunch of existing drawings and need to know this for inserting some cell's in bulk. Some drawings it works perfectly but not for others. Ive checked scales etc as far as I know they are OK.
Ideas? Screen shots below showing the X offset in the reference file dialog vs the VBA result.
Its worth noting, that some drawings my code works perfectly. Some its off by a semi-consistent offset (x and y).