In todays world pdf is an important format BUT adobe makes our lifes complicated...

  • Thread starter Thread starter Alexandre
  • Start date Start date
A

Alexandre

Hey,
I;m using PDFMaker 5.0 and i need to automate the conversion to pdf, I
am currently printing to a pdf file,

the problem is its asking me for a file name every time, how do i
bypass this prompt ?

from vba I would like to specify a name and save the file.

Can someone please help ??

Regards,
Alexandre
 
use _ACCESS_ in order to make your reports; and then just view with
snapshot viewer-- it is included with Office installation.

Adobe is too stupid to make reliable products. Sorry.

-Aaron
 
(e-mail address removed) wrote...
use _ACCESS_ in order to make your reports; and then just view with
snapshot viewer-- it is included with Office installation.

Adobe is too stupid to make reliable products. Sorry.
Click to expand...

Talk about stupid!

And what should the OP do if all the people who'd be reading the files
he needs to produce have Acrobat Reader but not the snapshot viewer?
Should the OP become a snapshot-wanker just like Aaron?!
 
Alexandre said:
Hey,
I;m using PDFMaker 5.0 and i need to automate the conversion to pdf,
I am currently printing to a pdf file,

the problem is its asking me for a file name every time, how do i
bypass this prompt ?

from vba I would like to specify a name and save the file.

Can someone please help ??

Regards,
Alexandre
Click to expand...

Have a look in the help. I would be suprised if PDFMaker doesn't have
an option to automate the file names.

PDFCreator (for example) has an option to use the following as a file
name:

YYYYMMDDHHMMSS.pdf

HTH,

Alan.


PS: PDFCreator is free software - look on Sourceforge.
 
Thankx Alan,

but here I am a slave of CSC and cannot install anything new on the
computers, if it were for my self it woul dbe something i would do in
a second but this is for a geographicly divided departement...

I will keep scratchin g my head and writing nice letters to adobe.

Thanks for the access idea, i just dont know how im going to go about
it though ... have an example ?

Alexandre
 
go play with your spreadsheets you dork.

PDF is a crappy app.. I mean.. Adobe Acrobat has got to be the buggiest
software ever written. Makes me wonder if the dorks from redmond are
really pulling the levers for Adobe..

Both MS and ADOBE smoke crack and can't make a decent, stable,
reliable, high-performance app.
I just wish that it was Macromedia that bought Adobe instead of the
other way around.

Macromedia-- now there is a good company.
 
(e-mail address removed) wrote...
THE SNAPSHOT VIEWER COMES INSTALLED WITH OFFICE YOU IDIOT
Click to expand...

No it doesn't, moron. It may come on the Office CD, it may even be a
default install option when installing Access, but it's *NOT* part of
Office Standard, so people who don't have Access almost certainly won't
have Snapshot viewer. But they will likey have Acrobat viewer, so guess
what file format SMART people would use?
 
Thank you Harlan,

well for whom ever desired to know how to accomplish what it was i
wanted to accomplish with pdfmaker 5 I have found a way to bypass the
annoying popup. Yes its more steps but it works, makes me feel good
that it works and makes my boss happy there for im happy :)

heres some code for all of you.

Dim GenericReportPsFile As String
Dim GenericReportPdfFile As String

GenericReportPsFile = Application.ActiveWorkbook.Path & "\"
& GenericReportTitle & ".ps"
GenericReportPdfFile = Application.ActiveWorkbook.Path &
"\" & GenericReportTitle & ".pdf"

' Get active printer.
strActivePrinter = Application.ActivePrinter
' Change to the Microsoft Fax printer driver.
'Application.ActivePrinter = "Acrobat PDFWriter on LPT1:"
Application.ActivePrinter = "Acrobat Distiller on Ne01:"
' Print the active document
Selection.PrintOut Copies:=1, printtofile:=True,
prtofilename:=GenericReportPsFile

Dim myPDF As PdfDistiller
Set myPDF = New PdfDistiller
myPDF.FileToPDF GenericReportPsFile, GenericReportPdfFile,
""

' Change back to the default printer.
Application.ActivePrinter = strActivePrinter

Kill GenericReportPsFile

You must include in your references the distiller object.

so you have to print to post script then convert to pdf using
distiller.

now I am looking to figure out how to append to pdf files or to ps
files so that i can add more than one report to my pdf.

Thank You all for your answers.
 
As for aaron.kempf
Dear sir please look around at most of all the PROFITABLE enterprises
on this nice earth of ours and ask your self what sofware gets these
companies to accomplish thier jobs and make them millions.. In many
cases you will observe a windows of some sort and in many cases a
office of some odd sort and in many of the casses you will obser that
they are all using bad software like adobe pdf writer or distiller....
umm i wounder... they make money and accomplish thier tasks with all
these BAD (as you expressed) software... if it was all that bad why
isnt the world on linux and open office or on mac os X for that
matter. One simple answer, people get the job done with what they
currently have and to have a company change software is a big thing.
second of all to have a company re educate thier employees to a new os
or new soft is long hard expensive and the resistance to change factor
is very high. in other words i understand that you do not like adobe or
ms but it would be great if you kept it to your self, i dont need to
know it and I for a fact like what i can do with MS soft & dev
environment therefore i stick to it! it gets the job done.

Thx everyone for the good responses, they were greatly apreciated.
 
you're full of shit harlan

Adobe Acrobat is the buggiest software ever written; and it's a tragedy
that those dorks are going to be put in charge of Macromedia.

How many times has adobe acrobat bugged you and said 'do you want to
check for updates'?

more importantly; WTF is acrobat doing being a TSR (terminate and stay
resident)
Does WORD still tie up memory after you close it?
Does EXCEL still tie up memory after you close it?

Adobe Acrobat has been doing this for years:
a) making your browser hang
b) slowing down Windows
c) annoyingly asking you every 30 minutes if you want to check for
updates

I mean.. WTF is up with that company?

SOMEONE is asleep at the wheel lol

I mean.. those dorks dont' take the clientside seriously enough.
 
listen you ****nut

just because your company is profitable; that doesnt make adobe acrobat
an acceptable platform.

those ****ers are going to get eaten alive

it's only a problem when companies hire excel dorks like yourself-- in
the REAL WORLD people have to learn software or else they dont work.

Do you know what would happen if I wasn't constantly learning new
programs and ways to do things?

I WOULDN'T GET A JOB.

Do you know what happens when your excel dorks use crap software to get
their software done?

THEY WASTE MONEY.

Your time will come; you ****ing excel dorks.

Grow up and start keeping pace with technology. You can do this PDF
bullshit with Access snapshots.
Why would you want to spend $100/seat for software you've already got?
 
Excuse me aaron,

but to simply talk simple stuff liek excell and vba and adobe makes you
irretable ..

i find it quite silly. and NO learning software wont keep an indefinete
job,
but when you are smart enough to learn programming and to be able to
follow what you boss sais and following company policies and ever
though you know something better is out there and you know how to keep
your mouth shut on it fo rthe right reason then you may work for a long
time. the point is dont scare people with new technologies if you dont
have to.

I'm a C# C++ Java ..... & many more type of guy and i work with what i
am given. in other words im flexible.

and if something does the job then it simply does the job.

thanks for your consideration on the subject, it was entertainning

Alexandre
 
(e-mail address removed) wrote...
Adobe Acrobat is the buggiest software ever written; and it's a tragedy
that those dorks are going to be put in charge of Macromedia.
Click to expand...

So many bugs! So many deluded people who ignore or don't even recognize
those bugs! Aaron alone among all the people on the planet realizes
this!

You need treatment. A nice, quiet room. lots of meds, . . .
How many times has adobe acrobat bugged you and said 'do you want to
check for updates'?
Click to expand...

Um, none. Unlike you I may know how to turn off auto notify 'features'
and opt not to receive e-mail. [That said, I still use Acrobat 4 (full
version, not Reader), and I see no need to upgrade.]
more importantly; WTF is acrobat doing being a TSR (terminate and stay
resident)
Click to expand...
....

since it took so long for older versions to load, that's an arguable
point. Do like I do - use an older version that doesn't 'function' this
way. Or learn how to write a script to unload all Acrobat processes
when it's not an active foreground application. Someone who claims to
be as knowledgeable as you do should be able to figure out how to
bypass this.

This isn't a bug, per se. It's a questionable to outright stupid design
decision. Lots of software, even some databases, have a few
questionable design 'features'.
 
I must agree with you Harlan,

though I am curious to see where adobe will take macromedia or vice
versa.

a smart conbination of both could endup being a nice stronghold...

Alexandre
 
more flexible? LoL

i use the same language in Excel macros, Access apps, DTS packages and
ASP.

That is called flexibility.
 
you use 4?

I haven't had any luck or stability with 5 or 6 or 7... so maybe i
should go back to the old ass version thanks

it takes a half hour for all versions to load.

I can open Excel FIVE TIMES in the amount of time that it takes PDF bs
to load.. i mean.. those dorks need to learn how to compile or
something lol
 
Back
Top