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

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.

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!

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!