save as cell reference to newly created folder

[JONESY]

Hi everyone

I'm trying to make an order pad and I'm having trouble saving.
I want to save the file by an order number reference in a sheet. I want to put that order in a folder by supplier ref. Now I've got the Code to look up and check whether there is a folder based on a cell reference and if not then generate a new folder. But when I try to do the save as command I can't seem to save the file name I want into the newly created folder
to create folder i have
MkDir "C:\My Documents\orders\" & Suppname
but to save filename I using
ActiveWorkbook.SaveAs Filename:="C:\My Documents\orders\" & Suppname & MyName, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=True, CreateBackup:=False
Which is saving the file in the Orders Folder

Sure I'm doing something daft but can't see what
Thanks for the Help

 

[JONESY]

sorry solved it sometimes that 5 minute cup of tea really does provide all the answers!