Hi!
I have an interesting nut to crack.
I am making a Word install program for Excel.
The install program executes from Word, checks if the updated font-file is installed (normal.dotm) and opens Excel (Workbooks.Open) if the lastest font-file is not installed.
On the install program in Excel I have the procedures for the installation in (Workbook_Open).
This installation deletes the old Font-file which can't be delete while Word is active, and replaces this with the updated fontfile.
The problem is that the VBA macro from Word won't stop before the macro in Excel is fininshed. This is ofcourse leads to the procedure to break, since normal.dotm can't be deleted while Word is open.
Is there a way to break a running macro in Word from a macro in Excel?
I have an interesting nut to crack.
I am making a Word install program for Excel.
The install program executes from Word, checks if the updated font-file is installed (normal.dotm) and opens Excel (Workbooks.Open) if the lastest font-file is not installed.
On the install program in Excel I have the procedures for the installation in (Workbook_Open).
This installation deletes the old Font-file which can't be delete while Word is active, and replaces this with the updated fontfile.
The problem is that the VBA macro from Word won't stop before the macro in Excel is fininshed. This is ofcourse leads to the procedure to break, since normal.dotm can't be deleted while Word is open.
Is there a way to break a running macro in Word from a macro in Excel?
