M
Maury Markowitz
I have a job that needs to run on a particular machine on our network. I've
been trying to do this by opening the spreadsheet using CreateObject, but
everything I try seems to end in some random failure -- most often freezing
the client machine's copy of Excel and requiring a force-quit.
So I'm basically giving up on DCOM as a solution. Any other suggestions on
how to do this? All I need to do is run a macro -- 15 to 20 seconds tops --
on the other machine and then continue when it completes. The macro doesn't
even have to be in Excel, it's calling a fairly benign ActiveX plugin that
runs just as easily in Access (and fails just as spectacularly using DCOM).
Maury
been trying to do this by opening the spreadsheet using CreateObject, but
everything I try seems to end in some random failure -- most often freezing
the client machine's copy of Excel and requiring a force-quit.
So I'm basically giving up on DCOM as a solution. Any other suggestions on
how to do this? All I need to do is run a macro -- 15 to 20 seconds tops --
on the other machine and then continue when it completes. The macro doesn't
even have to be in Excel, it's calling a fairly benign ActiveX plugin that
runs just as easily in Access (and fails just as spectacularly using DCOM).
Maury