VBA application crashing when linked to frontpage.
 

Excel application is in VBA , aim of application is to send mail to user groups based o
business rules as well as a form attachement. As a stand alone, the application works perfectly but when attache
as a link to a frontpage webpage (Local Intranet located on Network instead of server )the application hang
infinitely
Process
(1) user clicks the link to launch application in new window
(2) Application receives data input
(3) Progress window appears which ticks off all event stages . A
this point the the progress window disappears and the page is left hanging
Sometimes after a successfull run it reopens the VBA application. Is there anyway round thi
i.e frontpage setting , Excel setting, VBA requirement et

Extras
-----------------------
Excel VBA wersion 9
Explorer version 6.