ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calling a macro on a remote computer (https://www.excelbanter.com/excel-programming/322842-calling-macro-remote-computer.html)

Maury Markowitz

Calling a macro on a remote computer
 
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


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com