Macro to activate 2 workbooks

[light]

I recorded this macro in Excel 2016 with the macro recorder and want to insert vba . Of course the two files were opened already when the macro was recorded. I am poor in VBA and after looking at many examples of how to do this online cannot get it to work. Here is the Macro recorder's version.

Please Login or Register  to view this content.

The"Matrix" workbook has this code and where the data needs to be transferred to. The "Aqu010216.xlsm" is but one workbook of many with different names that will need to be opened (not simultaneously) to feed the Matrix workbook

[JJGF]

Horse Racing? PM me.

[light]

Yes it has to do with horse racing but it's still a spreadsheet like any other type.

[xladept]

Hi Light

See if it still works:

Please Login or Register  to view this content.

[light]

Thanks xladept. I get a "runtime error "438" Object doesn't support this property or method". Using debug it comes up after the line

Set wm = M.wm.Sheets(ActiveSheet.Name) is executed.

I've inserted the code in the module where the original macro recorder code was and also tried inserting in the "Matrix" sheets and get the same error message in all cases.

[JJGF]

should be:

Set wm = M.Sheets(ActiveSheet.Name)

[light]

Thank You JFGF. That worked when I made "Matrix" the active sheet.

[JJGF]

Thank You JFGF. That worked when I made "Matrix" the active sheet.

yw, I sent PM be back in a few.

[xladept]

Sorry for the silly mistake