Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » File & folder management
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
File & folder management
Resolved · Medium Priority · Version 2007
Reply Thu 9 Dec 2010, 15:47Delegate Tom said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Wed 15 Dec 2010, 20:39Delegate Tom said...
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
Reply Sat 18 Dec 2010, 15:45Delegate Tom said...
RE: file & folder management
Many thanks, Anthony
|