file system object

  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. C

    Getting error “specified network name is no longer available” as soon as I try to open file programatically (VBA)

    In VBA for excel I'm using the `FileSystemObject` to loop through the files in a folder, then when I find an excel file I'm trying to open it and update any hyperlinks in the file. Whenever I try to open a file in excel, I receive the error message `Run-time error '2147024832 (80070040)'...
  3. A

    File System Object Error

    Hello, I'm using the below code that I copied from another existing workbook, which automatically creates a pdf. file and generates an email in outlook express. It works perfectly on the existing workbook, but when I tried to copy it across to another workbook (changed relevant names) and ran...

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