Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating File Names
Is there a way I can automatically generate a file name
using the contents of a cell. i would like the user to be able to simply press Ctrl+s and save the file name as a unique number generated in a cell. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating File Names
Barry,
Try something like Activeworkbook.SaveAs Filename:= "C:\myTest\" & Range("A1").Value & ".xls" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Barry" wrote in message ... Is there a way I can automatically generate a file name using the contents of a cell. i would like the user to be able to simply press Ctrl+s and save the file name as a unique number generated in a cell. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file names | Excel Worksheet Functions | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
Generating a repeating list of names from an ever changing roster. | Excel Worksheet Functions | |||
embedding a macro when generating a CSV file | Charts and Charting in Excel |