open workbooks

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...

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...

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...

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...

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...

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...

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...