easy question (but i dont know the answer)

[Ahjem]

what macro should i use to

a) open a folder by clicking on a button (exactly the same as what the "open" icon does)

b) close the program (prompting to save as usual)

thank you

 

[jrnyman]

For b)

End the code with:

Application.displayalerts=true
Application.Quit

 

[Ahjem]

thanks

 

[Mr Nick]

For part a), do you want to open a specific file or just the open dialog to appear?

 

[Mr Nick]

I may as well just put both options here and then you can choose. Just put either of these codes on your button click.

Workbooks.Open FileName:="Enter The File Name Here"

Application.Dialogs (xlDialogOpen).Show

 

[Ahjem]

Thank you.

it was just the open dialogue i needed.