For b)
End the code with:
Application.displayalerts=true
Application.Quit
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
For b)
End the code with:
Application.displayalerts=true
Application.Quit
thanks
For part a), do you want to open a specific file or just the open dialog to appear?
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
Thank you.
it was just the open dialogue i needed.
Like this thread? Share it with others