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. |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com