How to use a macro to open files from sharepoint?

Hi all,

Hope all are well.

I am using below macro to open excel file from an online sharepoint link and its working successfully.

Please Login or Register  to view this content.

However, there are 9 more files to be opened and therefore i modified the line as below to open 2 files at once.

Please Login or Register  to view this content.

But now the code doesn't work. Can someone please help how to add code for multiple files? Thanks in advance.

Perfect. Repeating the Workbooks.Open code.

Thanks a bunch

Instead of writing a long path in each file, consider using the following macro:

Please Login or Register  to view this content.

Artik

@Artik.

That's great. Thanks a lot

Hi Artik,

Hope you are well.

Sorry but can you just help with 1 additional step.

After all files are opened, I want the code to take me back to sheet "Main Page" in the original file from where macro was run.

Could you please add this line at the end? Many thanks in advance.

Is it enough to add

Please Login or Register  to view this content.

?

Artik

Its working perfectly. Thanks a bunch for your lightning response