How to change macro excel VBA code from using legacy local path to SharePoint online path?

Question

Hi,

I have a macro enabled excel file which was initially stored locally on our network drive, AND NOW is moved to SharePoint online. Which is causing errors, as the the local drive is read only and the macro code is trying to open and save to a read only path on network drive.

I would like to change the path to the new SharePoint online path and I am not sure how to do this CORRECTLY.

Could I get some assistance on this? If I can handle one file, then would be easier to work on others.

Looking forward to a helpful response!

Thank you!

I get this error 'runtime error 75: path/file access error'

Another user gets this error: 'runtime error 1004: cannot access read-only document'

On debugging, looks like the macro still contains the legacy path of network drive.

I WOULD APPRECIATE ANY HELP I CAN GET ON UPDATING THE VBA CODE TO USE NEW SHAREPOINT PATHS.

Thanks in advance!

Error that I see:

https://learn-attachment.microsoft.com/api/attachments/c341d183-2622-4416-b668-15aab7ed4584?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/05ce66d5-d9be-4459-81e6-3c95400c589f?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Answer 1

Could you share the macro you are using? Then I can help you correct it.