Print To File Without Dialog

S

Sabine

Hello!

I am using MS Project 2003.
I have written a VBA macro which does the following for all resources in one
project plan:
1.) Creates a temporary project plan for one resource
2.) Print this temporary project plan as file with the following code:
psfile = sPsPath + sMail + ".ps"
If Dir(psfile, vbNormal) <> "" Then Kill (psfile)
SendKeys (psfile + "~")
FilePrint FromDate:=dFrom, ToDate:=dTo

This program works only when the workstation is not locked.
When the workstation is locked the SendKeys command does not work!

Does anyone know a solution without using SendKeys?

Thanks!

Sabine
 

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