Solved: Cannot switch to an active excel workbook from word

[sam3444]

Hi,
From a word macro, how can I switch to an excel workbook that is already open to run an excel macro within it?

Any examples online of working with excel through word show the need to open a new instance of excel and open the file in order to have access to it. I would like to avoid this as it takes a long time to open the workbook. And if this cannot be answered, then how could I switch to a specific document in word that is currently open through word vba?

[CatDaddy]

Me.Application.Workbooks.Open("C:\YourPath\YourWorkbook.xls")

there is a separate forum for word, but i think its Windows(DocumentName).Activate?

[Aflatoon]

Assuming you know the path of the workbook in question, you can use GetObject:

GetObject("C:\PathToFile\Workbook.xls").Application.Run "macroname"

for example.

[sam3444]

thank you both for your responses.

[CatDaddy]

which worked?