Print Single Pages to PDF Files

[Guest]

I have a macro that prints 10 to 15 different reports. The macro calls a VB
function to set the default printer, then it opens, prints, and closes each
report in turn. Is there a way to modify this macro so it sets the default
printer to Acrobat Distiller, then opens each report, calls a VB function
that prints page one to a specific PDF file whose name and location is the
same every time the report is run, then prints page two to PDF, and so on and
so forth, then closes that report and repeats the same process with the next
report?

And if this can be done, what is the basic syntax for the VB function?

I have looked at various tutorials and examples in these discussion groups
and on the Internet, so I think maybe it can be done. The problem is that I
am learning VB, and the examples and tutorials have a lot of "stuff" in them
I don't need, but I don't know enough VB to delete the unnecessary stuff and
still have the thing work.

Each month, I manually create about 50 PDF files by printing page 1 to PDF,
then page 2, and etc. So any help you can provide in automating this process
would be greatly appreciated!!!!!!

GwenH

 

[Arvin Meyer [MVP]]

Have a look at Steve Arbaugh's PDF and Mail class.

I print a PO report that's hundreds of pages to as many as 300 different
files using the code in that class, plus Win2PDF (which I recommend heartily
in place of the slow Acrobat distiller. Win2PDF creates and saves each file
in as little as 1/2 second.

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.win2pdf.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I appreciate the information ... the website you provided may be useful to me
in the future. Unfortunately, I work for a bank owned by a bank holding
corporation. We have very strict security protocols on our computer systems.
We cannot download applications of any kind off the Internet and install it.
We are only allowed to have the applications approved by the holding company.
I have to either write the code myself, or continue doing it manually.

Thanks for taking the time to reply to my inquiry.

GwenH

 

[Arvin Meyer [MVP]]

I appreciate the information ... the website you provided may be useful to me
in the future. Unfortunately, I work for a bank owned by a bank holding
corporation. We have very strict security protocols on our computer systems.
We cannot download applications of any kind off the Internet and install it.
We are only allowed to have the applications approved by the holding company.
I have to either write the code myself, or continue doing it manually.

Thanks for taking the time to reply to my inquiry.

I also work for a large public corporation that tightly restricts users.
Fortunately, I have a little more leeway being head of development. Steve
Arbaugh is a Corporate VP at a large Health Management group, so he is quite
familiar with high security requirements and HIPAA security restrictions.
Most admins are sympathetic to specific developer requests if they are given
adequate notice and documentation. Since both of the apps I discussed are
not free, you'll need their permission to buy them anyway.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Sorry, I guess I wasn't clear enough in my previous post. The holding
corporation that owns my bank has a list of "approved" applications they
allow users to have on their computers. They will not consider "special"
requests. If it's not something they've already decided you need, and
something they've already got on their "approved" list, then you don't get
it. Period. No amount of documenting, begging, or bribing will change that.