folder picker

  1. B

    Folder Picker

    I'm trying to loop through files in a folder and I'd like to allow the user to select the folder that they would like to loop through. What am I doing wrong here: Sub GetSummaryData() Dim wb As Workbook, ws As Worksheet Set fso = CreateObject("Scripting.FileSystemObject") SelectFolder =...
  2. H

    How do I export to the same network drive that we start from using vba in excel?

    This is my first post at Mr. Excel but I appreciate all the help I've received just doing searches. Alas, I'm not able to find an answer to this next question, possibly because I don't know the right words to use. Here's my dilemma, and then I'll post the code. In this part of our...
  3. E

    Folder Picker

    I am having trouble with the following code. It appears to be a very simple answer that eludes me. There is a Master Director that certain files will be copied from to a folder of the users choosing. I used the folder selector dialogue box for the selection but no matter which folder the user...
  4. WERNER SLABBERT

    Print and Save to specific folder indicated by cel in worksheet.

    Morning all you smart people... i have a vba code that saves and prints a document to a folder. i would like to expand it somewhat to ref a cell and then save the doc to the right folder. currently it just saves to one folder. i need it to look at 'B9' and the find the corresponding folder and...
  5. V

    Replace folder path with folder picker vba

    Hi, I have this code which works fine, currently I have to type the folder path in the code, I want to use folder picker in place of that. Please suggest the changes to be made. Sub Example1() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer 'Create an...
  6. K

    Loop Through Files in Directory

    I'm writing a code to loop through all the files in directory location (specified by the user), and process them to send to our customer. I'm having trouble with pulling files from the directory. Currently I can't get past the bold line of code. Yesterday I could get to the second bold line...
    • KnoxQual
    • Thread
    • directory files in directory folder picker loop vba
    • Replies: 2
    • Forum: Excel Questions
  7. S

    Using FolderObj = FileSystemObj.GetFolder("Folderpath") the Folder path as through Folder picker

    Hi All, I want to use the below line in my excel vba : FolderObj = FileSystemObj.GetFolder("Folderpath") However i want the Folder path to be Dynamic that's it will ask the user to choose the folder through Folder picker or some other command. Any help how i can achieve the same. Thanks in...

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