Hello
Can anyone pls modify the below code snippet to accomodate the sharepoint link?
Please let me know if you have any questions.
Thanks in advance.
Can anyone pls modify the below code snippet to accomodate the sharepoint link?
Code:
GetData "\\102.29.103.009\Backup\New folder\Updated" & "\UpdateFile.xlsx", "Sheet1", _
"A1:G2", Sheets("TheWheel").Range("A1"), True, True
Code:
https://microsoft.sharepoint.com/teams/New Folder/Shared Documents/Consolidate/Updated/UpdateFile.xlsx
Please let me know if you have any questions.
Thanks in advance.