reference workbook name

  1. C

    in the formula the workbook name is given from another cell

    Hi Guys, Sorry if the question is stupid. Is it possible to get the workbookname - in the below formula - from another cell? e.a.: the workbook name is in cell C1 and the formula is in D1 ='C:\[workbookname.xlsx]Sheet1'!$A$10 Is it possible to do that the workbook name is given into the...
  2. S

    VBA to return to a workbook whose name has been changed

    Hi, Is there a way to write VBA in excel 2010 to cycle back to an open workbook (A) whose name has been changed? When this workbook (A), whose name changes each time it's released to user, runs through and a series of Macros, it leads them down a path to a newly created workbook(B). I need the...
  3. L

    VBA Workbook index referencing failure

    I have a Module that has operated great for years, but now on a new computer, it is fails. The error message I receive is runtime error #9, which is subscript out of range. I recognized the problem to be that it did not like the reference: Workbooks(1).Worksheets("Corrected Data").Range("B8"...
  4. J

    Workbook name Reference error

    I have created a template named “Stock Quantity Calculator 2007 Template 10K a2.xltm” with many macro in it. When opening a new workbook with this template I am getting errors because some of the code is looking for the template name not the newly created workbook name. What would be the code...
    • Javi
    • Thread
    • active workbook name reference workbook name workbook name
    • Replies: 5
    • 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