save as and open

[ladbroke]

What id like to do is to have an command button on a userform which once clicked, opened up the save as function.

Id like another command button that also opens up the open file function.

can someone please help with a formula for these two?

 

[agihcam]

to display saveas;

application.getsaveasfilename

to display open function;

application.getopenfilename

 

[ladbroke]

i cant seem to get these to work..

i want to use command buttons.. how do i write them into the formula?

 

[agihcam]

i cant seem to get these to work..

i want to use command buttons.. how do i write them into the formula?

when you are using a command buttons, you're doing a macro program isn't it? so something like;

Private Sub CommandButton1_Click()
Application.GetSaveAsFilename
End Sub
Private Sub CommandButton2_Click()
Application.GetOpenFilename
End Sub