Tom has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel VBA Advanced course
Access Introduction course
File & folder management
some applications have a pop-up box that enables the user to browse the computer to save / open etc a file. How can I set that up on my applications?
RE: file & folder management
Hello Tom,
Hope you enjoyed your course with BEST Training.
Thank you for your question regarding pop ups.
Not sure I understand fully the question. To open any pop up in all applications for viewing files and folders would be just the standard Save/Open dialog, in all applications this is Control+O to Open or Control+S.
If you have an example please send it over.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
RE: file & folder management
Thanks, Mark.
Say for example I write a 'year end' routine for an excel application whereby the user is prompted to save a 'year end' version, prior to the procedure running. I want the user to be given a message to save the file, and I want a box to pop up (driven by the code), whereby they can select where to save the file. Rather like when you attach a file to an email a box pops up, with all the drives etc with a browse option that lets the user set out the path to the file they want to attach.
Is that possible?
Regards,
Tom
RE: file & folder management
Hi Tom, thanks for your query. You need to be able the standard File management dialog boxes from within your code. This is the line of code you need:
Application.Dialogs(xlDialogSaveAs).Show
Hope this helps,
Anthony
