RichardHowe
New Member
- Joined
- Jan 8, 2021
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Just wondering if anyone can help...
We have an old excel workbook that runs some VBA code, however we have recently moved to a SharePoint system and the macro now fails.... I have tried replacing the code (sarting W) but having no luck.
This is the bit of code in question
file.CopyFile "i:\impdata\fstock\sindex.ind", "W:\Departments\Accounts\SINDEX.IND", True
Where it states "W:\Departments\Accounts\SINDEX.IND" this is now a SharePoint site, i thought it would be just be as simple as putting the replacing the old path with the site, but that fails.
Is there something i am missing?
We have an old excel workbook that runs some VBA code, however we have recently moved to a SharePoint system and the macro now fails.... I have tried replacing the code (sarting W) but having no luck.
This is the bit of code in question
file.CopyFile "i:\impdata\fstock\sindex.ind", "W:\Departments\Accounts\SINDEX.IND", True
Where it states "W:\Departments\Accounts\SINDEX.IND" this is now a SharePoint site, i thought it would be just be as simple as putting the replacing the old path with the site, but that fails.
Is there something i am missing?
