open workbooks

  1. K

    EXCEL for MAC: Event Macro to Open 2 workbooks at same time

    The macro below is copied from a Windows VBA tutorial. Doesn't work on my Mac. Can anyone sort out the syntax problem? It should open a dialogue box to locate the file that should be opened. I want to open a second workbook when a first WB is opened. Thanks. Sub...
  2. C

    VBA to Open Workbook not working

    Hi, This macro was working previously. It has suddenly stopped working with "Run-time error '1004': Sorry, we couldn't find D:\Users\D801878\Int'l\Billing\2017_03\Billing Template_International_2017_03_SG.xlsx. Is it possible it was moved, renamed or deleted?" My code is something like...
  3. W

    Save as copy and then use that copy

    Hello, I think I'm asking for more than is possible here but it's worth asking nonetheless. I'm trying to make it so that on click of a button for my excel sheet to: Save. Save a copy in my documents Use that new copy to run a print macro. Currently I can get it to save and then create the...
  4. F

    ListBox Display is empty - Help!

    I am new to VBA... I have a combo list box that points to another workbook and worksheet. When I manually open the 2nd workbook and worksheet, my listbox works perfectly. Everything is great. However... writing VBA code to open the workbook automatically, the listbox is empty. The workbook...
  5. R

    Activeworkbook.worksheets error: object doesn't supoprt this method

    Hello,I am working in excel/access 2003. I have a macro running out of access in which I create an excel workbook (a copy of an existing template) and try to paste the results of several access queries into this workbook. I first try to check if a copy already exists or not. If it does I delete...
  6. T

    How to search all open workbooks

    hello all, first-time poster, long-time reader. (using excel 2007) I was hoping to get some help with a small VBA problem I am having. The basic idea of my program will have an input box with a text input and "Go" button. When something is input and and "Go" is engaged, it will search all the...
  7. L

    Skip Corrupt Workbooks In a loop

    I have a list of 34,000 *.xls files, some corrupt, some not, no way to tell. I need a way to loop through them, ignoring "this file cannot be opened" error messages, open the valid ones, run my code, close the workbook and move on to the next. I have a workbook listing all the filenames if...

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