Hi, I am calling an excel sheet from matlab, and while i have the sheet open it is running a macro. This macro then tries to activate other workbooks, but is getting a subscript out of range error because it only knows about this excel sheet. When I open the excel sheet manually and run the macro it works fine. I can't figure out a way to fix this - we basically need to make the excel sheet called from matlab aware of other workbooks.
Solved by Z. Y. in 26 mins