khalid79m
11-18-2011, 04:00 AM
I keep getting the following error
Run-time error '1004':
Method 'Open' of object 'Workbooks' failed
Application.Workbooks.Open (FullP), , True
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
Run-time error '1004':
Method 'Open' of object 'Workbooks' failed
Application.Workbooks.Open (FullP), , True
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