How to jump Cute pdf writer dialog print box with VBA.
Hi I am actually trying to add a step in a MS Access-Word mail merge, that allows me to create the equivalent file in .pdf
Unfortunately I cannot manage to avoid tiping ENTER at each time the document goes to print.
I have tried SenKeys method, but with no result.
I was thinking to something like:
Dim PrintDialogBox as application
PrintDialogBox.visible=fal
With PrintDialogBox
SendKeys ENTER
End WIth
to repeat after each printing steps.
Can you suggest please? Thanx.
Unfortunately I cannot manage to avoid tiping ENTER at each time the document goes to print.
I have tried SenKeys method, but with no result.
I was thinking to something like:
Dim PrintDialogBox as application
PrintDialogBox.visible=fal
With PrintDialogBox
SendKeys ENTER
End WIth
to repeat after each printing steps.
Can you suggest please? Thanx.
ASKER
Now it works, since it does not ask to Save the file with the dialog box, but it creates a huge .pdf file that cannot be opened by Adobe since appears to be corrupted.
I think that it depends on my freeware version of Cute; if you know a cheap pdf writer that:
1) can be configurated as a virtual printer
2) works with your code
3) (eventually) is useful also to convert .pdf to .jpg
you're welcome.
I think that it depends on my freeware version of Cute; if you know a cheap pdf writer that:
1) can be configurated as a virtual printer
2) works with your code
3) (eventually) is useful also to convert .pdf to .jpg
you're welcome.
I have never created a pdf file. I just know how to programme printing to a file and understand that most pdf creators work like that. I downloaded PDF995 in case I needed it to answer your previous question, but I haven't had time to try it. It has been recommended several times in postings in the Word. The site claims that it can convert to pdf to jpeg
http://www.pdf995.com/
http://www.pdf995.com/
ASKER
Very nice: it performs SendKeys command, but I have no idea on:
1) making invisible the dialog box (I cannot actually perform in creating the application)
2) use the wdApp.ActiveDocument.Print
1) making invisible the dialog box (I cannot actually perform in creating the application)
2) use the wdApp.ActiveDocument.Print
1. Which dialog box?
2. Does creating the pdf from the document work if you do it manually?
2. Does creating the pdf from the document work if you do it manually?
ASKER
When you launch a print with pdf995 (but also with others such as Cute) a print dialog box appeaars asking you to confirm file name and path. If I use the SendKeys method there is no problem, but I 'd prefer to:
1)identify that dialog box
2)give a command line that allows my routine to jump to that dialog box
3)use the sendkeys method
Can you post some code for that? Thanx.
1)identify that dialog box
2)give a command line that allows my routine to jump to that dialog box
3)use the sendkeys method
Can you post some code for that? Thanx.
I have now created a PDF file (my first) using pdf995 . It seems to act differently from the Adobe writer which I think can use the PrintOut method to a file. Perhaps that is why pdf995 is free.
I don't use Sendkeys. You may have to use the FindWindow API to get the handle of the dialogue.
I don't use Sendkeys. You may have to use the FindWindow API to get the handle of the dialogue.
ASKER
I don't have any function like that in my MS Access 2000 library.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window