files names

  1. K

    Renaming Worksheet VBA to insert in Longer VBA

    I am trying to split out a workbook with about 100 tabs into separate excel files, so I can PowerQuery them. I have it to the point where it splits out my files and renames them and puts them all in a folder, BUT I would LOVE if I could figure out how to also have the VBA rename the worksheet...
  2. I

    Getting filenames into excel?

    I have about 10,000 files that I need to create an excel spreadsheet containing all of their names. Is there a way to just pull the filenames into excel without actually pulling the actual file in. Basically if I open my folder can I get the names of all of the files in that folder into excel?
  3. D

    Automate hyperlinks

    I would like to create a hyperlink to pdf files in a folder based on the matching name in a cell of a excel spreadsheet. I have pdf files that have a document name: helpme1.pdf, helpme2.pdf, helpme3.pdf, for example, in the same folder as the spreadsheet. The names are in a cell, lets say...
  4. A

    Linking many source files to a single data table

    Dear Excel gurus, I have a customer whose Finance Controller is spending hours (if not days) every month to produce a Balanced Scorecard. He has set up links from the scorecard to over 20 external files. There are two challenges as I see it: 1) The names of those files change monthly (i.e...
    • afarcet
    • Thread
    • feeding data files names linking data pivot table
    • Replies: 2
    • Forum: Excel Questions

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