filename from cell value

  1. J

    Open file based on text in filename

    I am trying to create a procedure runs when a workbook is opened (Event: On_Open) that does that following: 1) Open a file with the text "ELA" in it from the same folder 2) Copy a specific set of cells from the first opened workbook (i.e. H15:I17) 3) Paste those cells into the "ELA" workbook in...
  2. G

    Macro to find missing extensions

    Hi, I'm a newbie...just to state that up front, please don't throw rocks! ;) I'm a creative designer by trade, but have been getting into more 'expanded' requirements by clients. Anyways, here's my question, I have an ongoing monthly gig that I'm supplied with a spreadsheet that includes...
  3. B

    Getting filename path and placing in a cell

    Hi Apologies if this has been posted before. I know similar things have but can't fine exactly what I need. I have a workbook with a named range "Appendices". Cells $B$20:$B$30. If I change the value of one of these cells to "YES" using a dropdown list then I want the explorer pane to open so...
  4. J

    Reference filename based on Cell contents

    Hello all, I have found a number of threads on this subject, but all point towards using '=indirect()' or a macro. The problem with the indirect function is that I cannot consistently have the referenced file open, hence a #REF error. I also do not want to use a macro due to the volatility of...
  5. S

    Macro to automate : a.) Saving of Open Worksheet as new Excel file, b.)Print command to print 2 copies each with different footer, and some more queri

    All for the same file :) a.) I have an invoice template in one excel file in which I fill in data, out of which some of it auto fills as it is linked to another excel file in which the master data is stored and updated. I wish to edit this invoice "template" (if u may call it that:)) and once I...

Watch MrExcel Video

This Week's Hot Topics

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
Top