From the immediate window as a demonstration:

Range("C17").Value = "Microsoft"
? "C:\" & Range("C17").Value & " - Purchase Order - " &
Application.Text(Now(),"dd.mm.yy") & ".xls"
C:\Microsoft - Purchase Order - 01.09.03.xls

--
Regards,
Tom Ogilvy

David Chances wrote in message
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.