anthony20069
10-09-2009, 02:07 AM
Hi guys,
I have the following VBA code
ActiveWorkbook.SaveAs Filename:=myfilepath & "Saved Assessments\Both Assessments\" & fileSaveName & ".xls"
But when ever the button is click the following
"Run-time Erroe '1004'
Microsoft Office Excel cannot access the file 'file path'. there are several possible reasons:
- path doesnt exist
- path being used
- same name as another workbook"
Basically what i need it to do, is look at where the spreadsheet called "Assessment Application.xls" is located on the laptop, and there is a folder called Saved Assessments to which the file needs to be saved at....
Hope that makes sense...
I have the following VBA code
ActiveWorkbook.SaveAs Filename:=myfilepath & "Saved Assessments\Both Assessments\" & fileSaveName & ".xls"
But when ever the button is click the following
"Run-time Erroe '1004'
Microsoft Office Excel cannot access the file 'file path'. there are several possible reasons:
- path doesnt exist
- path being used
- same name as another workbook"
Basically what i need it to do, is look at where the spreadsheet called "Assessment Application.xls" is located on the laptop, and there is a folder called Saved Assessments to which the file needs to be saved at....
Hope that makes sense...