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:

Full screen mode for YouTube

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:

Changing resolution

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.

This page has 1 thread Add post
30 Apr 20 at 18:55

hi can you please share the excel.

I will be very greatfull to you


please reply

01 May 20 at 06:43

Hi Deepu,

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. 

04 May 20 at 19:20

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.


Andrew G  
05 May 20 at 07:23

Hi Deepu,

Happy to hear that you're finding the videos useful. Thank you for watching!