Creating multipage PDF from password protected Woorkbooks.

[paulbaucom]

I have to do billing through our clients password protected Excel
Workbook. After entering in our information the expect for us to email
it back as a multi-sheet PDF. The problem is that the password
protected workbook will not create multi-Sheet PDFs it it says "please
verify if you have modification rights to the document." Does anyone
know a workaround?

Our client uses Macs and PCs they now expect us to ditch all our Macs
for PCs becouse they said they did not have any problems on any of
their PCs.

 

[CyberTaz]

Hi Paul -

I have to do billing through our clients password protected Excel
Workbook. After entering in our information the expect for us to email
it back as a multi-sheet PDF. The problem is that the password
protected workbook will not create multi-Sheet PDFs it it says "please
verify if you have modification rights to the document." Does anyone
know a workaround?

Our client uses Macs and PCs they now expect us to ditch all our Macs
for PCs becouse they said they did not have any problems on any of
their PCs.

I don't really mean to be sarcastic, but if the last para is worded
correctly & the client has both Macs & PCs where "...they did not have any
problems..." why won't they share the process with you? That way you could
handle things exactly the same as they wthout having to resort to a
workaround.

If that can't be done, my first thought is that you don't really need a
"work_around_" as much as you need a "work_a-right_" IOW, it sounds like
you are relying on the built-in utility of OS X to generate your PDFs and
finding that it *ain't* Acrobat Professional. I would need to test it before
being sure, but I believe that is the problem. That utility is quite handy &
does an excellent job of generating quality PDFs as long as the source files
present *nothing* that deviates from plain vanilla. Even without the pw
issue, however, you might still have difficulty using only it to generate
multi-page XL PDFs.

I believe you need to do one of two things: either remove the pw protection
temporarily while you generate the PDF or invest in a more capable PDF
generator that has more guts. I honestly have not tried to generate a PDF
from a pw protected XL file, so I can't say for sure without testing it, but
I have found the utility guilty of creating multiple PDFs using the same
files on which Acrobat sucedded in creating a single multi-page PDF.

There are also PDF "stitcher" apps available that allow you to combine
multiple PDFs into a single file, but I'd consider that as a "last resort".

 

[John McGhie]

Hi Paul:

Chances are, your client is using the Adobe PDFMaker.dot application on
their PCs. This has much higher capability than the equivalent one for the
Mac. (The Mac version of PDFMaker is both feeble and irritating: we
recommend that Mac users uninstall it).

What I suggest that you could do is make a copy of the Exel sheet, remove
the password from it, save as PDF, then discard the copy. Provided that you
save the copy within your Documents folder on your local Mac, nobody who
shouldn't see it will be able to, and you already know the password

Cheers

--

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs

+61 4 1209 1410, <mailto:[email protected]> mailto:[email protected]