Saving a Worksheet

[anthony20069]

Hi guys,

I have the following VBA code
[vba]ActiveWorkbook.SaveAs Filename:=myfilepath & "Saved Assessments\Both Assessments\" & fileSaveName & ".xls"[/vba]
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...

[Bob Phillips]

It is very hard to say without knowing what is in myfilepath, but maybe

[vba]

ActiveWorkbook.SaveAs Filename:=myfilepath & "\Saved Assessments\Both Assessments\" & fileSaveName & ".xls"
[/vba]