Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving an Excel Spreadsheet with a particular name - Beginners
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set up spreadsheet for beginners | Setting up and Configuration of Excel | |||
Beginners Question setting up spreadsheet | New Users to Excel | |||
How can i reverse saving an excel spreadsheet. | Excel Discussion (Misc queries) | |||
Saving an Excel Spreadsheet with a particular name - Beginners | Excel Programming | |||
Saving excel spreadsheet in a cell | Excel Programming |