VBA - WORKING WITH FILES VIDEOS
VBA - working with files videos | Excel VBA Part 24 - File Dialogs
Posted by Andrew Gould on 11 March 2014
Using FileDialogs in VBA provides a convenient method for selecting files and folders and performing useful actions on them. This video covers how to use the standard FileOpen and SaveAs dialogs, and how to perform their default actions. The video also covers the use of the FilePicker and FolderPicker dialogs and how to use FileSystemObjects to process a collection of selected files to perform actions such as copying files to another folder.
You can increase the size of the video:
You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.
You can also increase the quality of the video:
You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.
Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.
hi can you please share the excel.
I will be very greatfull to you
I'm sorry but this video doesn't have an Excel file available for download. All of our newer videos have downloadable files and you can find the links for these in the description above each video.
Ok Andrew thanx no issues
Your vidoes and the way you explain each every step is amazing.'
I am lucky to find you website and I am learning a lot here.
Happy to hear that you're finding the videos useful. Thank you for watching!