Refer to opened workbook in different Excel Application

Asked Jul 08 '16 at 12:41

Active Jul 08 '16 at 13:06

Viewed 498 times

I want to set a reference to another workbook, that is already opened, in another Excel application. I can already set a reference to the other workbook when it is opened in the same application using

Set wbBOS = Application.Workbooks("wb2.xlsm")

This works because Application.Workbooks can find "wb2.xlsm". However if I open another instance of Excel and use the same line, it obviously does not find it within Application.Workbooks.

How can I set a reference to wb2 in that case?

EDIT: Given I know the full path, I can apparently set a reference to another application using :

 Set wbBOS =GetObject(path)

However I still get errors using Application functions such as

With wbBOS.Sheets("BOS")        
        If Application.WorksheetFunction.CountA(.Cells) <> 0 Then

Where it works fine if it is open in the same Application. How can I solve this?

edited Jul 08 '16 at 13:06

asked Jul 08 '16 at 12:41

David G

2,315
1
24
39

1

As long as you know the full path, you can use `GetObject("path to workbook")` – Rory Jul 08 '16 at 12:43
As in `Set wbBOS =GetObject(path)` ? – David G Jul 08 '16 at 12:45
1

Check [**this**](http://stackoverflow.com/a/32312737/1652222) link. – ManishChristian Jul 08 '16 at 12:58
Possible duplicate of [How getObject Function internally works?](http://stackoverflow.com/questions/32304831/how-getobject-function-internally-works) – Ralph Jul 08 '16 at 13:01
@DavidG Yes, like that. – Rory Jul 08 '16 at 13:14
@Rory Please see the EDIT in my question – David G Jul 08 '16 at 13:18
Use `wbBOS.Application` rather than just `Application` – Rory Jul 08 '16 at 13:20

Refer to opened workbook in different Excel Application

0 Answers0