Server calls from Word VBA

J

John

Hi

Is it possible to start a program on a server somehow from Word VBA on a
different machine.

The server program would be required to email a few people with a copy of
the document and insert it into another doc as well as create a PDF of the
doc.

Am I barking mad, or is this possible.

(Server is Win2000 Server with Office 2k and IIS installed.

Please help if poss!

Cheers
JJ
 
S

Steve Hudson

G'day "John" <[email protected]>,

Word doesnt work in a server context. You can start progs on servers
though, stick the CMD line in a Shell "..." statement.



John said:
Hi

Is it possible to start a program on a server somehow from Word VBA on a
different machine.

The server program would be required to email a few people with a copy of
the document and insert it into another doc as well as create a PDF of the
doc.

Am I barking mad, or is this possible.

(Server is Win2000 Server with Office 2k and IIS installed.

Please help if poss!

Cheers
JJ

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

If answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.
 
J

John

Changed my mind... the server just needs to email people now using an email
component. The clinet needs to send some kind of a packet to the server
with a filename and a few other bits of info. The server needs to pick up
the packet and send a unique email with a the file attached.

JJ
 
W

Word Heretic

G'day "John" <[email protected]>,

use Save As or the VBA file open, print#1 etc to create the parm file
on the server then issue your shell command to launch the resultant
app that emails or whatever.


Steve Hudson
Word Heretic Sydney Australia
Tricky stuff with Word or words

Email: Steve at wordheretic.com


John was spinning this yarn:
Changed my mind... the server just needs to email people now using an email
component. The clinet needs to send some kind of a packet to the server
with a filename and a few other bits of info. The server needs to pick up
the packet and send a unique email with a the file attached.

JJ

Steve Hudson

Word Heretic, Sydney, Australia

wordheretic.com

If answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top