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.