View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz Maury Markowitz is offline
external usenet poster
 
Posts: 86
Default Calling Excel macro remotely?

"Tom Ogilvy" wrote:

Look at CreateObject in VBA help in xl2000 or later. Note that the last
argument is ServerName.


Thanks Tom, it looks like this is what I need. I'm having some problems
trying to figure out what security settings are needed to allow it to work
(right now everything gives me a permissions error) but other than that it
seems simple enough.

Maury