Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA - Calling Save As Dialog

Status
Not open for further replies.

BGumm

MIS
Joined
Feb 26, 2008
Messages
12
Location
US
I'm lost trying to figure out how to require the user to save a workbook as something else when a certain event occurs (e.g.:

Code:
Private Sub cmdConfirmNewData_Click()

    'NEED TO BRING UP THE SAVE AS DIALOG BOX

End Sub

)

Help is very appreciated!

::Bryan
 
Please repost this VBA-specific question in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top