http://www.rdpslides.com/psfaq/FAQ00053.htm is for Distiller. You should be
able to change the driver code to PDFMaker.



--

John

johnf202 at hotmail dot com


"Tom S" wrote in message
...
I looked here, but am I supposed to create an .INI file or am I to replace
one that is already there? If I'm to replace one that is already there, I
may have a problem since I can't find that file. Also, I am using windows
2000 pro, not WIN 98, so should this file go in the WINNT folder and then
in
system?
Thanks.

"Dick Kusleika" wrote in message
...
Tom

Try here



http://www.google.com/groups?threadm...SFTNGP10. phx.
gbl

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Tom S" wrote in message
...
Sorry about that, I'm using PDFWriter (part of Acrobat 4.0). But I
can't
figure out the syntax in VBA to print the sheet and automatically save
it
without prompting the user.

"Richard Choate" wrote in message
...
How to expect to convert the new data to pdf? Are you using a pdf
driver?
The pdf driver should allow you to create the pdf and overwrite the
existing
one, if there is an existing one.
--
RMC

"Tom S" wrote in message
...
How can I code a line in the VBA to first delete a sheet, and then
(with
1
sheet remaining) print to a PDF file automatically by passing the
arguments
of the name and path that the PDF is supposed to have? Please help.
Thanks!