partial file name

  1. A

    locate and open worksheet

    Hello Everyone the code below currently opens the worksheet "Element list - Export.xlsx". Dim wkb2 As Workbook Set wkb2 = Workbooks.Open("C:\Users\andym\Desktop\Excalibur Winner\ExcaliburProPlus\_ExcaliburDataConfig\Element list - Export.xlsx") I need to run this code on other computers...
  2. E

    Using VBA to open files in a folder using partial file names

    I found the code below but it is not working. I am trying to find a code that will find a file utilizing where only the first two characters in the file name are know. This is in Excel 2010. My file names will always be AA_MMM_YYYY.xlsx, BB_MMM_YYYY, CC_MMM_YYYY where the "MMM" changes each...
  3. R

    Selecting a Workbook using partial name

    Hi All, Imagine I have 3 Workbooks open with File names ABC12345, DEF54321, GHI00000. These partial names are present in a column of an excel workbook say XYZ (ABC in A1 cell, DEF in A2 cell, GHI in A3 Cell) I want a macro which can select(or activate) the respective workbook by reading the...
  4. Z

    Insert partial filename in cell A1

    I need a way to insert the part of the file name after PO. In the example below, 3351 is the work order number, between brackets is the customer name, then the description and then the PO number. The problem is the PO number varies in length and could contain digits, dashes etc. so I need to...
  5. J

    VBA open most recent file in folder with specific string in filename

    I am looking for some code that would open the most recent file in a folder if the file name starts with a specified string (e.g. Testfileyyymmdd.xlsx) I found this code that opens the most recent file, but does not take into account the filename: Sub GetMostRecentFile() 'To use...

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