98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » File & folder management
File & folder management
Resolved · Medium Priority · Version 2007
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?
Wed 15 Dec 2010, 10:11Trainer Mark said...
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
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
Fri 17 Dec 2010, 15:05Trainer Anthony said...
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
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. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |
