Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autoname a save as file from a cell in a read only file
I have a read only file set up to type in monthly staff hours, when you go to
save the file it points you to a save as box as it is a read only file. I have used concatenate to use information from the table to produce a standardised file name. Is there any way to set the properties so when the save as box appears it will name the file from a cell in the table? Cheers Garod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autoname a save as file from a cell in a read only file
If you use a macro, you could show the dialog with that drive/folder/filename:
Option Explicit Sub testme() Dim myFileName As String With Worksheets("Sheet1") myFileName = "C:\temp\" & .Range("A1").Value & ".xls" End With Application.Dialogs(xlDialogSaveAs).Show myFileName End Sub g4rod wrote: I have a read only file set up to type in monthly staff hours, when you go to save the file it points you to a save as box as it is a read only file. I have used concatenate to use information from the table to produce a standardised file name. Is there any way to set the properties so when the save as box appears it will name the file from a cell in the table? Cheers Garod -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autoname a save as file from a cell in a read only file
ps.
If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm g4rod wrote: I have a read only file set up to type in monthly staff hours, when you go to save the file it points you to a save as box as it is a read only file. I have used concatenate to use information from the table to produce a standardised file name. Is there any way to set the properties so when the save as box appears it will name the file from a cell in the table? Cheers Garod -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
Automatically save file based on cell value | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
cannot save file - folder is read only | Excel Discussion (Misc queries) |