Hyperlink to excel macro

[Ed in Aus]

I am having a bit of trouble with an auto opening excel macro when it is activated via word doc.
It brings up an error: "This action cannot be completed because the program to which you are navigating is busy"
is there an easy walk around for this?

 

[BrianB]

I have seen that this can happen if Autosave is switched on.

Could use a macro in Word like :-

Sub OPEN_EXCEL()
    Set xl = CreateObject("Excel.Application")
    xl.workbooks.Open ("F:\test\book1.xls")
    Set xl = Nothing
End Sub

 

[Ed in Aus]

It bring up an "unexpected error" I have come up with a walk around for this though, instead of have the macro 'auto open' I just created a command button in the excel spreadsheet to open the macro this has no errors, thanks for you r help though