filenames from excel list

  1. R

    Extract Month from file name

    Hi, I need to extract the month of the year from the file name. \\srv-ef-w-001\shared\Financial Statements\Financial Statements\Month End 2016\12 December 2016\[Lease Disclosure - December.xlsx]Voucher Summary The file path above I used the cell filename function to get the full address of...
  2. J

    Get the file path without the file name

    Hello , i have a long list of file directories on a spreadsheet. Intially i wanted to seperate the file name. i was able to find a post online which allowed me to do this get filename from filepath and filename But now i would like to just have the file path without the file name So if...
  3. 5

    Seek to open Word text files from file names list stored in Excel worksheet

    I am new to writing VBA macros and trying to gain proficiency, while trying to get work accomplished at the same time . I now use VBA to open a number of text files, one at a time in Word, complete modifications, and then resave in advance of use elsewhere. What I would like to do is further...

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