How to use CreateGUIDString to open Excel file instead of OpenObject (1 Viewer)

HI

I have programmed a number of Access/VBA applications using the OpenObject/CreateObject methods to link to Excel Spreadsheets or Word Documents and transfer data etc.

Now these are not working and returning an "Error 70 - Permission Denied". From research it seems that this is due to some security updates from Microsoft which deactivated the CreateObject("Scriptlet.TypeLib") option.

I saw Microsoft's recommended workaround with the CoCreateGUID but I have not found an explanation of how one should apply this to still create or open an excel spreadsheet etc...

Do you have some sample code, beyond what was proposed by Microsoft (i.e. Type and Function declarations and code for the CreateGUIDString Function)? I need to know how to call this functions within my code to link to Excel or other office applications.

Thanks

Cross post https://stackoverflow.com/questions...ring-to-open-excel-file-instead-of-openobject

And fullest answer looks like here:
https://stackoverflow.com/questions/45332357/ms-access-vba-error-run-time-error-70-permission-denied