'Macro and SharePoint

I have macros set up in a spreadsheet, but I have now changed from a drive on a server to SharePoint and need to edit the macro to point to the share point. The following is the code as it was

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,'F:\Grants and Projects\Timesheet Reports\[Staff Look Up.xlsx]Staff Look Up'!C1:C8,6,0)"

How do I change this so it points to the SharePoint file, as at the moment the macro fails as the original file is not there now. I don't want to redo the whole of the macros as it is a huge macro. I would like to edit the macro.

Thanks

excel vba

Solution 1:^[1]

You need to provide the sharepoint path

= "=VLOOKUP(RC1,'https:<yoursharepoint website with path>/[Staff Look Up.xlsx]Staff Look Up'!C1:C8,6,0)"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Storax

'Macro and SharePoint

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]