Creating a pdf file

[cparsons]

I am creating several excel spreadsheets using a vba macro. Onc
finished I would like to convert each spreadsheet to a pdf seperately.


I have purchase adobe acrobat 6.0 standard edition to do this with.

I have read how this can be done but, I guess because I am new don'
really understand the lingo.

Can anybody expain this process easily or show a snippet of code?

Your help would be appreciated

 

[John P]

CP,

You should have a little adobe acrobaticon on your toolbar?

If not go to View Toolbars and at the bottom you should see it?

John

 

[Lady Layla]

In Excel, open a file, go to page setup and look at your printer options, you
should have a pdf option
(I use pdf995 - which is free), select that, it will ask for a file name and
site, print there and open the file to double check


: I am creating several excel spreadsheets using a vba macro. Once
: finished I would like to convert each spreadsheet to a pdf seperately.
:
:
: I have purchase adobe acrobat 6.0 standard edition to do this with.
:
: I have read how this can be done but, I guess because I am new don't
: really understand the lingo.
:
: Can anybody expain this process easily or show a snippet of code?
:
: Your help would be appreciated.
:
:
: ---
: Message posted
:

 

[cparsons]

Thanks for all your suggestions but I was trying to do this all from the
macro. I did find this code that creates a PS file then calls the
distiller and creates a PDF.

The PSFileName is the name I want to call the PS file
The PDFFileName is the name I want to call the PDF file.


SendKeys PSFileName & "{ENTER}", False
ActiveSheet.PrintOut , PrintToFile:=True


DistillerCall = "C:\Program Files\Adobe\Acrobat
6.0\Distillr\Acrodist.exe" & " /n /q /o" & PDFFileName & " " &
PSFileName


ReturnValue = Shell(DistillerCall, vbNormalFocus)


The PS file seems to be created correctly but when the distiller is
called the application goes down with the following error

%%[ Error: undefined; OffendingCommand: &l1T ]%%
%%[ Flushing: rest of job (to end-of-file) will be ignored ]%%
%%[ Warning: PostScript error. No PDF file produced. ] %%


I'm not sure what the problem is or why the error is happening.

In the DistillerCall I see the distiller executable is called the the
ps and pdf files are passed but what does /n /q and /o do???

Any suggestions??

 

[Myrna Larson]

Where did you find the information on the syntax for calling Distiller? That
same source should explain what the switches do. BTW, did you check the Adobe
site? I didn't find anything helpful there...

 

[cparsons]

I found it at http://www.planetpdf.com/mainpage.asp?webpageid=762

I did browse Adobe's site but it wasn't much help. I'm new to this and
the site seemed to high level for me.

Thanks,

 

[Myrna Larson]

Thanks for the URL. I couldn't find anything useful on the Adobe site.