Saving an Excel Spreadsheet with a particular name - Beginners
 

hi,

Try this code
NameToday = "C:\" & Range("c17").Value & " - Purchase Order - " &
Application.Text(Now(), "dd.mm.yy") & ".xls"




"David Chances" , iletide sunu yazdi
om...
Cant seem to get this Save Function to work:

At the moment I have:

NameToday = "C:\ Purchase Order - " & Application.Text(Now(),
"dd.mm.yy - ") & Range("c17").Value

I want to change the order of what is saved, at the moment this
creates a file called:

Purchase Order - 01.09.03 Microsoft.xls [on the c drive]

I want to call it:

Microsoft - Purchase Order - 01.09.03.xls

I cant seem to get that to work by re-arranging the formula

Can anyone help.
Many thanks.