INS support forum    


Welcome to the Integrated Notification System support forum.
Before entering a query/request please search the forum to see if someone else has asked the question before.
Please feel also free to respond to queries from other users if you have experienced the same type of problem and found a solution to it. 
Our support team will monitor this forum and endeavour to provide answers to the queries posted.
Please make sure to post your query to the right forum as there is a separate forum for each application provided by MAW Software.
Show messages for: Last 7 days Last 30 days All (Digest of all)

Back to the forum

On Monday , the 05.05.2003, MAW Support wrote at 15:08:25 :

>Offline Fax printing in Scripts

Greg,

So you are using the
ActiveSheet.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)
VBA function in Excel.
The problem seems to be that if you define a PrToFileName (IE "d:\temp\faxprt.apf") Windows will bypass the driver as it requires a manual action (the fax number), so the file is created using the standard Windows printer.
PS works obviously as it does not require any further user interaction.
Not quite sure how to overcome this. I tried to set the PrToFileName to "" which brings up the "Send fax to..." box. Here you may use the SendKey command to simulate the entry of the file name... It will work, but is not very nice ...
So the PS to TIF conversion seems to be the better alternative.

Rds
TL






Post reply:

Name:
E-Mail:
Subject:
Message:
SPAM code displayed
next to this:

CGIForum (C) Markus Triska

Home to