![]() |
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