Save-As with Cell Name

[sassriverrat]

hello-

I've been trying to write a piece of code to save-as a workbook. Here are the criteria- and I can fill in the "xxx's" if someone lays them out for me. Help is much appreciated.

Needs to save-as on a C:\Users\Bridge\Desktop\Noons\Noons-Arrivals\(Myfile)

The name needs to come from sheet "Notes" and Cells R8+R9+R10

I'd like a dialogue box to open up for the save location


thank you for your help. My attempts haven't worked.

 

[sassriverrat]

Ok- so I went back to play with this again- seems to still throw the same error code as before. I checked the path and it seems right. I went so far as to delete (as you will see below) the entire path except for C drive and it still produces the same error. The debugger only highlights the section of code I have below.

 ActiveWorkbook.Saveas Filename:="C:\" & cPath & ".xls", FileFormat:= _        xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False