Open ObjectOct 19, 2009
I have inserted a workwook in another workbook that the user will have to edit and save changes from time to. I have the excel file inserted as an object. when I double click it the file opens and I can save changes made.
I'm trying to create a macro that can open the object from other tabs. i used the macro recorder and got this
Windows("Worksheet in SBATrendReport2010").Visible = True
ActiveWindow.WindowState = xlMaximized
The problem I'm having is I get a error message when I run the macro
"subscript out of range.