I keep getting the following error

Run-time error '1004':
Method 'Open' of object 'Workbooks' failed

[vba]
Application.Workbooks.Open (FullP), , True
[/vba]

This code works fine in excel 2010 and 2003 but when u launch it via link on an intranet site , the file opens and runs fine, when the user clicks the macro to get the relevant data, the excel runs the above code and fails.

Can anyone help