Show sheet as a PDF file

[Oeysbrei]

Hello,

Is there a code I can use to show a a sheet from my workbook as a single PDF file by pressing a button from another sheet?

Regards
Oeysbrei

[Paul]

Perhaps see either of these sites for instructions:

http://www.rondebruin.nl/pdf.htm

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

(Ron is the author of both pages, and provides many examples of working with Excel.)

[Oeysbrei]

Thanks for youre reply.

I have only been working with VBA and macros for a few months, so the code from the posted websites dident make sence to me.
Does anybody have a code for this purpose that will only open a selected sheet from a workbook as a PDF file.

Regards
Oeysbrei

[Oeysbrei]

Hi,

I have this code that makes me save a single sheet in a PDF format.
What I need is the saved file to be opened after saved. What more do I need to add to this code to make it perform this task.

Please Login or Register  to view this content.

When I try to open this file manually, I get a message that tells me it cant get opened because the format is not supported.
Is there a way I can solv this?

Regards
Oeysbrei

[Paul]

If you record a macro of you saving a worksheet as a PDF you'll see the code that you need to adjust to fit your model.

Please Login or Register  to view this content.

Edit your sheet name (or variable.. Ark5?) as needed.

[Oeysbrei]

Paul,

THANK YOU, it worked perfect.
Now the rest will be a walk in the park until next project.

Regards
Oeysbrei

[Oeysbrei]

Paul,

It worked perfect once, but after that I get an error wile it tryes to open the file. The error is in adobe and tells me access denied.
Do you have any idea why?

Regards
Oeysbrei

[Paul]

Unfortunately I don't know the reason. It is working for me in my simple test workbook without error. I can press the button to create a file, it opens, and whether or not I close the file I can press the button again and it creates another file (and opens it).

[Oeysbrei]

Paul,

The file opens fine when I open it from were itīs saved, so itīs a mystery.
I guess I will have to try update adobe.

Thanks

Oeysbrei