Activate unsaved workbook from another workbook

**klallen810** · 05-16-2013, 12:48 PM

Hello,

I am trying to activate an unsaved workbook from a seperate workbook. The unsaved workbook is a report that is exported from another program into excel, I want to reference this workbook from a macro in a seperate workbook. I have tried

Windows("Book1").Activate
Workbooks("Book1").Activate

I have tried Dim wb as Workbook and then assigning Book1 to be wb, same with the worksheet within book1. Every time I do this i get the subscript out of range error, which I know means I am attempting to reference something that the macro isn't finding. I am thinking this might be because the two workbooks are seperate instances of excel? If anyone has any ideas let me know! Thanks!!

Kendra

**tehneXus** · 05-16-2013, 01:52 PM

Originally Posted by klallen810

I am thinking this might be because the two workbooks are seperate instances of excel?

I think that's the reason. You cannot use a book which is opened in another instance of Excel.

**ducky_yeng** · 05-16-2013, 08:16 PM

Hi klallen810

I checked online and find a bit of standard code and have tried and tested it on Excel 2010.
Hope this helps.

Please Login or Register  to view this content.

For completeness, this is how I tested it.

Paste the code into your saved Excel file
Create a new Excel blank file and do not save it (default workbook name is "Book1")
Run the code -> watch Book1->Sheet1->Cell(1,1) get updated with "hello there"