folderpicker

  1. M

    VBA to get File Names & Files Path from a folder to a Excel File

    Hello Everyone, i am struggling with the below code with 2 specific requirments. Here is my code & requirments : 1. Instead of writing down the folder name here "Set objFolder = objFSO.GetFolder("C:\Users\UserName\FolderName")" , is it possible to use FolderPicker option so that it will...
  2. V

    Execute macro on multiple excel files after after selecting folder from multiple levels

    I have research this question and found some VBA code that works if one folder is selected that has the excel files contained in it. If I try to drill down through multiple folders and subfolders, the code quits and indicates through the message box that it has finished when it really hasn't...
  3. E

    FolderPicker

    i am trying to automate the selection of 300 master documents into a project specific directory. The directory path changes per project, so it is important that the end user selects the folder. I am in word and am trying to use the msoFileDialogFolderPicker to select the current directory. It...
  4. J

    how to adapt from FolderPicker input to file path as variable?

    Hi all! I found this code online a while back and have been using it and it works great, but now I'd like to remove the user input from the process and instead derive the folder path from variables that were assigned earlier in the macro... The previous version... Sub GetFileNames() Dim...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top