findfile

  1. Oldrat

    VBA Open Hidden Workbooks Question

    Hi I am trying to open hidden workbooks using vba then change the attributes to vbnormal, if I use the specific workbook name, this code works fine. Sub Macro1() Workbooks.Open Filename:="D:\Lee\Downloads\KLT-TempZvQkUb084152" MsgBox ActiveWorkbook.Name SetAttr ActiveWorkbook.FullName...
  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. A

    Vba to confirm all files are present

    Hi All, I hope you can help. I am trying to find a macro that can check if certain files are present in their respective sub-folders before running another macro, and if not which ones are missing. I have found vba examples to check just one file but not multiple. I basically want the macro to...
  4. K

    How to find a specific file on a folder from an output cell in a worksheet and create a link to it?

    Hi, I am absolutely new to VBA and I am trying to create an excel worksheet that would let me select from lists of 3 or 4 options (e.g. Board type, board number, version, etc) and output the file name in a cell. Well, I got this far. Now, I want to use the "file name" in the output cell to...

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