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

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
 
A

aaron.kempf

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
 
H

Harlan Grove

[email protected] 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?!
 
A

Alan

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.
 
A

Alexandre

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
 
A

aaron.kempf

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.
 
A

aaron.kempf

yeah do a find for northwind.. open a report and 'export to snapshot
format'
 
H

Harlan Grove

[email protected] 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?
 
A

Alexandre

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.
 
A

Alexandre

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.
 
A

aaron.kempf

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.
 
A

aaron.kempf

listen you fucknut

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

those fuckers 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 fucking 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?
 
H

Harlan Grove

[email protected] 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'.
 
A

aaron.kempf

more flexible? LoL

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

That is called flexibility.
 
A

aaron.kempf

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
 
A

aaron.kempf

lol yeah

i just think that it's ridiculous.. someone at Adobe needs to learn how
to program
 
G

greaseman

Aaron, you air-headed dimwit!!

So, someone at Adobe needs to learn how to program???? Wonder how
they've sold as much of their product as they have?!?!

I think I've got you figured out....... You bitch about Adobe being
squirrelly
You bitch about
Excel
You bitch about
Access
You bitch and bitch
and bitch

To me it sounds like YOU need to learn how to program!!
Whassamatterforyou????? Don't know what a computer is for? Don't know
how to program??? Don't know how to hold a job (like the one you lost
at Microsoft)?? Just DON't KNOW??????

You are pea-brained, or maybe it's pee-brained.

Go hide in a corner
 
Top