How to open another workbook from a separate workbook and run a macro on the one opened

I am having trouble getting a macro on an .xlsm to work right so I am trying to do a run around and get what I need to be converted to an .xlsx.

I have a workbook that exports a sheet and saves it as .xlsx file the code is
It works great when using the macro on the same workbook.

Please Login or Register  to view this content.

Now I have separate workbook that when my macro runs on that sheet that it would open this other workbook and run the above code on that opened workbook.

I tried using this but it does not work I put it above the other code

Please Login or Register  to view this content.

any thoughts

Originally Posted by bdouglas1011

How to open another workbook from a separate workbook and run a macro on the one opened

Try

Please Login or Register  to view this content.

Where "Book1.xlsm" is the name of the workbook with the macro to run.

Tried but it opens and the just sets there it does not execute the export.

Also the name of the workbook will always be different can the Book1 be changed to adjust to the newly opened files each time

Please Login or Register  to view this content.

automatically use the name of the file opened

it is in the one that is being opened.

In short I have 3 different workbooks with the same sheet names and formats ... after the workbooks are completed ...I would like to link all 3 to another sheet to combine and track data off a particular sheet within all 3 workbooks.

I had no luck so I then I tried to just open the workbook and copy the data into my new one ...one at a time but that did not work either. (They are all .xlsm)
So I tried doing it with each individual sheet exported and saved as an (.xlsx) and I could get that to work. It just takes a while to do all the steps.

The only difference is the workbooks are (.xlsm) and the individual sheets are saved as .(xlsx)

I have tried even having the code in my new workbook but after it opens the .xlsm workbook nothing else happens no code ever runs.
I have a sheet that is what I am using until I get this working I could attach it and let you look at it. and the other workbooks. to see if you can understand it.
and if you think it might work