Excel/VBA/SharePoint - link all 3 not working

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?

Your thread title doesn't say much - please update it to indicate what sort of help you are after.