Turning pages into PDF
 

I couldn't find a Microsoft group for PDFs so I am asking you folks here. I
assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that - and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message ...
I couldn't find a Microsoft group for PDFs so I am asking you folks here. I
assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that - and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

Dean,

If you're not using Excel 2007, then you do need something like Distiller.
I got a copy of Adobe Acrobat 7 and it comes with Distiller. It has a
simple little object model that you can interact with to turn Excel data
into PDF.

There are probably non-Adobe options as well but I didn't want to screw
around.

josh




"Ron de Bruin" wrote in message
...
Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and I wonder where I can get a legitimate copy of it relatively cheaply
and within a few days. Somewhere I saw something about
edirectsoftware.com. Does anyone know if this is a good choice? Or any
others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

There is a link on my site for other versions


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Josh Sale" <jsale@tril dot cod wrote in message ...
Dean,

If you're not using Excel 2007, then you do need something like Distiller.
I got a copy of Adobe Acrobat 7 and it comes with Distiller. It has a
simple little object model that you can interact with to turn Excel data
into PDF.

There are probably non-Adobe options as well but I didn't want to screw
around.

josh




"Ron de Bruin" wrote in message
...
Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and I wonder where I can get a legitimate copy of it relatively cheaply
and within a few days. Somewhere I saw something about
edirectsoftware.com. Does anyone know if this is a good choice? Or any
others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

Sorry I didn't see the link for earlier versions of Excel. Very nice.

josh

Turning pages into PDF
 

Yes, I see that. It suggests something about being tested for EXCEL 2003
and 2007. I only have 2002 but I downloaded the main file and it seems to
work like a charm. I am a little confused as to whether I needed to
download more files, there were five of them (version 9.0.3), one just a
read me file, one with ghostwrite another not, not sure what the others
were, but I just downloaded the ghostwriter one and it seems to work fine.

This is fantastic Ron and I thank you very much. I've wasted tons of time
with EPSV'ing proprietary EXCEL files and deleting macros in order to send
reports to others but it looks like those days are finally over. Is this
software I am supposed to donate money for?

Dean

"Ron de Bruin" wrote in message
...
There is a link on my site for other versions


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Josh Sale" <jsale@tril dot cod wrote in message
...
Dean,

If you're not using Excel 2007, then you do need something like
Distiller. I got a copy of Adobe Acrobat 7 and it comes with Distiller.
It has a simple little object model that you can interact with to turn
Excel data into PDF.

There are probably non-Adobe options as well but I didn't want to screw
around.

josh




"Ron de Bruin" wrote in message
...
Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I couldn't find a Microsoft group for PDFs so I am asking you folks
here. I assume some of you, like me, like to take EXCEL pages and turn
them into PDFs. I guess I need the PDF writer, or is it distiller, to
do that - and I wonder where I can get a legitimate copy of it
relatively cheaply and within a few days. Somewhere I saw something
about edirectsoftware.com. Does anyone know if this is a good choice?
Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks here. I
assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that - and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

I think this is the same link that Ron provided, for versions earlier than
2007.

"Jim Thomlinson" wrote in message
...
I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I
assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

Dean

I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:34:41 -0800, "Dean" wrote:

I think this is the same link that Ron provided, for versions earlier than
2007.

"Jim Thomlinson" wrote in message
...
I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I
assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

I'm not sure what this has that I don't already now have, so I'm not going
to look further. It's sounds like this takes two steps rather than only one
with the link provided on Ron DeBruin's to Ken Puhl's site for versions
prior to 2007. If you know yours to be better, kindly let me know.

Thanks, Gord!
Dean

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Dean

I have had success with the free file downloads and instructions for use
here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:34:41 -0800, "Dean"
wrote:

I think this is the same link that Ron provided, for versions earlier than
2007.

"Jim Thomlinson" wrote in
message
...
I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks
here.
I
assume some of you, like me, like to take EXCEL pages and turn them
into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about
edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

Dean

Not better, just an alternative.

Gord
On Thu, 8 Mar 2007 21:54:57 -0800, "Dean" wrote:

I'm not sure what this has that I don't already now have, so I'm not going
to look further. It's sounds like this takes two steps rather than only one
with the link provided on Ron DeBruin's to Ken Puhl's site for versions
prior to 2007. If you know yours to be better, kindly let me know.

Thanks, Gord!
Dean

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Dean

I have had success with the free file downloads and instructions for use
here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:34:41 -0800, "Dean"
wrote:

I think this is the same link that Ron provided, for versions earlier than
2007.

"Jim Thomlinson" wrote in
message
...
I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks
here.
I
assume some of you, like me, like to take EXCEL pages and turn them
into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and
I wonder where I can get a legitimate copy of it relatively cheaply and
within a few days. Somewhere I saw something about
edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

OK, thanks much.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...

Dean

Not better, just an alternative.

Gord
On Thu, 8 Mar 2007 21:54:57 -0800, "Dean"
wrote:

I'm not sure what this has that I don't already now have, so I'm not going
to look further. It's sounds like this takes two steps rather than only
one
with the link provided on Ron DeBruin's to Ken Puhl's site for versions
prior to 2007. If you know yours to be better, kindly let me know.

Thanks, Gord!
Dean

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Dean

I have had success with the free file downloads and instructions for use
here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:34:41 -0800, "Dean"
wrote:

I think this is the same link that Ron provided, for versions earlier
than
2007.

"Jim Thomlinson" wrote in
message
...
I kinda like the one discussed here. It's free... it works without
advertising popups... and it has the ability be interact with code.

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson


"Dean" wrote:

I couldn't find a Microsoft group for PDFs so I am asking you folks
here.
I
assume some of you, like me, like to take EXCEL pages and turn them
into
PDFs. I guess I need the PDF writer, or is it distiller, to do
hat -
and
I wonder where I can get a legitimate copy of it relatively cheaply
and
within a few days. Somewhere I saw something about
edirectsoftware.com.
Does anyone know if this is a good choice? Or any others to
recommend?

Thanks much!
Dean

Turning pages into PDF
 

I was using this PDF Creator all along and being very happy with it. But
now, I cannot highlight three adjacent worksheets and have it create a
3-page PDF file. I am sure I was able to do it before. As soon as I hit
print, it deselects two of the three and creates only a one page PDF. Does
anyone have any idea what my problem might be?

Dean

"Ron de Bruin" wrote in message
...
Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I assume some of you, like me, like to take EXCEL pages and turn them into
PDFs. I guess I need the PDF writer, or is it distiller, to do that -
and I wonder where I can get a legitimate copy of it relatively cheaply
and within a few days. Somewhere I saw something about
edirectsoftware.com. Does anyone know if this is a good choice? Or any
others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

It seems that the problem is that I am now printing in a file that has the
following macro in it.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ThisWorkbook.Worksheets
wkSht.PageSetup.RightFooter = "&8Date : " & _
Format(Date, "dd-mmm-yy")
Next wkSht
End Sub

I assume this is what is causing it to deselect the multiple sheets I
highlight when I try to print with PDFCreator. Whether or not you agree,
can someone tell my why I would have been advised to put this macro in "this
Workbook" within my EXCEL file? I recall being told to do it from you folks
as a response to some special problem I was having, but I cannot recall, for
the life of me, what that problem might have been. I don't think I would
have added this macro strictly to automatically populate footers, which is
what it seems to do. Any ideas what I might have been trying to
accomplish?!

Thanks!
Dean


"Dean" wrote in message
...
I was using this PDF Creator all along and being very happy with it. But
now, I cannot highlight three adjacent worksheets and have it create a
3-page PDF file. I am sure I was able to do it before. As soon as I hit
print, it deselects two of the three and creates only a one page PDF. Does
anyone have any idea what my problem might be?

Dean

"Ron de Bruin" wrote in message
...
Hi Dean

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I couldn't find a Microsoft group for PDFs so I am asking you folks here.
I assume some of you, like me, like to take EXCEL pages and turn them
into PDFs. I guess I need the PDF writer, or is it distiller, to do
hat - and I wonder where I can get a legitimate copy of it relatively
cheaply and within a few days. Somewhere I saw something about
edirectsoftware.com. Does anyone know if this is a good choice? Or any
others to recommend?

Thanks much!
Dean

Turning pages into PDF
 

From Excel Help:

"Microsoft Excel uses the ampersand to initiate codes for special
formatting in the headers and footers."

I believe the "&8" in your code sets the font size to 8 (can't verify
for sure).

The default behavior in a footer is for "&[Date]" to print as
"9/20/2007", or something similar.
The code you mention puts the current date in the right footer as "Date
: 20-Sep-2007".

If you still need this date in this format on your pages when they are
written to PDFCreator, then I would move this macro code to a standard
code module and connect the routine up to a commandbar button, to be
used just before printing to PDFCreator.

Alternatively, you could get somebody to revise the macro to leave the
selected sheets selected. Hopefully, somebody will answer this thread,
or you could post this as a new question.
--
Regards,
Bill Renaud

Turning pages into PDF
 

Hi Dean,

I tested this on my machine (Excel 2000), and it works fine, when printing
to a regular printer. Something somewhere else is unselecting your
worksheets before being printed to the PDF file, as the For each statement
does not change the selection status of the worksheets.

Have you tried stepping through the code in your workbook to see where the
sheets are being deselected?

--
Regards,
Bill Renaud

Turning pages into PDF
 

Actually, I notice that it happens sometimes just trying to select two
sheets and print them to a PDF manually. It seems to depend on either the
name of the sheets or something seemingly arbitrary like that. In other
words, I don't think it's the macro now. Sorry.

Thanks!
Dean

"Bill Renaud" wrote in message
. ..
Hi Dean,

I tested this on my machine (Excel 2000), and it works fine, when printing
to a regular printer. Something somewhere else is unselecting your
worksheets before being printed to the PDF file, as the For each statement
does not change the selection status of the worksheets.

Have you tried stepping through the code in your workbook to see where the
sheets are being deselected?

--
Regards,
Bill Renaud

Turning pages into PDF
 

Do you have any event handlers attached to the worksheets in the workbook?
Right click on each sheet tab, then choose "View Code" from the context
menu. Any code window that is displayed might have the line "Option
Explicit" at the top, but should not have any routines in it (like "Private
Sub Worksheet_Activate", "Private Sub Worksheet_Deactivate", etc.

If they do (have any event handlers like those I mentioned), then those
could be the culprit and might have to be disabled or removed. Click the
"Design Mode" button on the Visual Basic toolbar so that the button remains
depressed.
--
Regards,
Bill Renaud

Turning pages into PDF
 

No, nothing there. This file is a grocery list file and in fact I created a
couple of tabs to test it in a very simple file.

Two of the four sheets save to PDF together. But in the case of one of them
with a 3rd tab instead, it asks me for two file names and creates two
one-page files.

Any idea why? The whole thing almost seems random!

Thanks!
Dean


"Bill Renaud" wrote in message
. ..
Do you have any event handlers attached to the worksheets in the workbook?
Right click on each sheet tab, then choose "View Code" from the context
menu. Any code window that is displayed might have the line "Option
Explicit" at the top, but should not have any routines in it (like
"Private
Sub Worksheet_Activate", "Private Sub Worksheet_Deactivate", etc.

If they do (have any event handlers like those I mentioned), then those
could be the culprit and might have to be disabled or removed. Click the
"Design Mode" button on the Visual Basic toolbar so that the button
remains
depressed.
--
Regards,
Bill Renaud

Turning pages into PDF
 

Oh and, by the way, in these cases it does not deselect the tab. Also, I
notice that if I try to print the problematic paid to my printer, it prints
them both. It seems to be problem with the PDF Creator program interface.

D


"Dean" wrote in message
...
No, nothing there. This file is a grocery list file and in fact I created
a couple of tabs to test it in a very simple file.

Two of the four sheets save to PDF together. But in the case of one of
them with a 3rd tab instead, it asks me for two file names and creates two
one-page files.

Any idea why? The whole thing almost seems random!

Thanks!
Dean


"Bill Renaud" wrote in message
. ..
Do you have any event handlers attached to the worksheets in the
workbook?
Right click on each sheet tab, then choose "View Code" from the context
menu. Any code window that is displayed might have the line "Option
Explicit" at the top, but should not have any routines in it (like
"Private
Sub Worksheet_Activate", "Private Sub Worksheet_Deactivate", etc.

If they do (have any event handlers like those I mentioned), then those
could be the culprit and might have to be disabled or removed. Click the
"Design Mode" button on the Visual Basic toolbar so that the button
remains
depressed.
--
Regards,
Bill Renaud

Turning pages into PDF
 

I have never used PDF Creator myself, but have only done Excel VBA
programming, so can't help much with it.

--
Regards,
Bill Renaud

Turning pages into PDF
 

You can make your PDF files turning pages like a real book with free trial version of Kvisoft Flipbook Maker Pro(http://www.kvisoft.com/flipbook-maker-pro/ ).