MS office path in VBA

Hi,

In VBA we frequently get error related to office files or library path for e.g missing 'Object Library'

My observation is that if we have created VBA program where the path for object library is c:\program files\Microsoft office\office 16 and if the program is run on machine which doesn't have Office 16 folder then the above mentioned error comes while executing the program.

Is there any way to define in the program where the required library is automatically selected irrespective of the version on the machine?

A quick solution will be appreciated.

Thanks in advance

Regards,

Sandeep