Programming Excel "drop-down menu" functions

D

DaveG.

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
 
B

Bob Phillips

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. said:
I am trying to program an Excel workbook, so as to minimise the user's
Click to expand...
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
Click to expand...
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
Click to expand...
SAVED with a predefined name & extension.
 
D

dave good

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!
 
B

Bob Phillips

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)
 
Top