Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel "drop-down menu" functions
I am trying to program an Excel workbook, so as to minimise the user's keyboard actions. The actions I am trying to macro/prog. are as follows:
1. After data has been entered on a worksheet, activate SAVE AS for the workbook, the user then inserts a "name" for the file (XLW extension inserted automatically), accepts 2. On completion of the above, designated cells are "cleared" and workbook SAVED with a predefined name & extension Purpose is to eliminate possible user errors. Any assistance gratfully rec'd Dave G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel "drop-down menu" functions
Do
sFile = InputBox("Filename") Loop Until sFile < "" ActiveWorkbook.SaveAs Filename:=sFile & ".xlw", _ FileFormat:=xlExcel4Workbook What does this have to do with a drop-down menu? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "DaveG." wrote in message ... I am trying to program an Excel workbook, so as to minimise the user's keyboard actions. The actions I am trying to macro/prog. are as follows:- 1. After data has been entered on a worksheet, activate SAVE AS for the workbook, the user then inserts a "name" for the file (XLW extension inserted automatically), accepts. 2. On completion of the above, designated cells are "cleared" and workbook SAVED with a predefined name & extension. Purpose is to eliminate possible user errors. Any assistance gratfully rec'd. Dave G. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel "drop-down menu" functions
Bob, Many thanks for your reply. However, you answered the 1st part of my problem, could I ask you to look at the 2nd part (clearing selected cells, then saving the workbook. BTW - I have a friend who lives in Christchurch, near the river, I can understand the pleasure of your location. Nice part of the country. Rgds., Dave G. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel "drop-down menu" functions
Didn't you want that then?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "dave good" wrote in message ... Bob, Many thanks for your reply. However, you answered the 1st part of my problem, could I ask you to look at the 2nd part (clearing selected cells, then saving the workbook. BTW - I have a friend who lives in Christchurch, near the river, I can understand the pleasure of your location. Nice part of the country. Rgds., Dave G. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
how to hide "All" in drop-down menu of my pivot table | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
have a "drop down menu" appear in a data form | Excel Programming |