Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Attributes / Save As New File Name
Having reset a worksheet to zero, how can I force users to
use a new filename, rather than just Save and defaulting to existing name. Can I set Read Only attribute for currently open file or alternatively bring up File Save As and only accept new name entries? Many Thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Attributes / Save As New File Name
Read only will do the job!
Nikos Y. (nyannaco at in dot gr) -----Original Message----- Having reset a worksheet to zero, how can I force users to use a new filename, rather than just Save and defaulting to existing name. Can I set Read Only attribute for currently open file or alternatively bring up File Save As and only accept new name entries? Many Thanks Paul . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Attributes / Save As New File Name
"Paul Moles" wrote in message ... Having reset a worksheet to zero, how can I force users to use a new filename, rather than just Save and defaulting to existing name. Can I set Read Only attribute for currently open file or alternatively bring up File Save As and only accept new name entries? Many Thanks Paul Hi Paul: You can set the starting file to read only just by going into Windows Explorer ... right click on the file name ... properties ... tick read only. Alternatively, you can do it in VBA: SetAttr "C:\MyFile.xls", vbReadOnly BUT you can't do that for a file that is already open! What you can also do is ask the user for the file name (either by inputting it on the spreadsheet or through an input box). You can then check whether the file already exists before saving by using While Dir ("C:\MyChosenFileName") < "" Code to ask user to choose a different file name Wend |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
Getting NTFS file attributes | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
File Attributes | Excel Discussion (Misc queries) | |||
syntax of changing file attributes | Excel Programming |