My colleagues Mark Middleton, Ed Chase and I offered an eSeminar today on collaborative review tools.

The eSeminar featured solutions for ad hoc review using Acrobat and also audited, workflow-based review using the Adobe eSubmissions Solutions Accelerator.

Here, you can view the slides from today's session.

I've stored these on my Acrobat.com account so you can view a Flash preview or download the PDF which includes speaker notes.

Read the rest of the entry to get to the downloadable slides.

Travel budget? Not a problem!

I'll be racking up the frequent flyer miles on Adobe's Acrobat Forum Tour to bring you Acrobat 9 in Chicago, Columbus, Cincinnati, Seattle and San Francisco.

Yep, that means you can have a close personal experience with Rick Borstein and receive a three-hour demonstration of Adobe Acrobat 9.

Free breakfast included . . . what's not to like?

Oh, the features! See PDF Portfolios, forms, redaction, conversion tips, export to Word and Excel, security and a lot more.

Adobe Acrobat 9 Forum

Chicago, IL
Tuesday, September 15


Register Now

Time
9:00 am - 12:30 pm (CST)

Where
Gleacher Center
450 North Cityfront Plaza
Chicago, IL 60611
(312) 423-8000

Columbus, OH
Wednesday, September 16


Register Now

Time
9:00 am - 12:30 pm (EST)

Where
Capital Club
41 South High Street
Columbus, Ohio 43215
(614) 228-0225

Cincinnati, OH
Thursday, September 17


Register Now

Time
9:00 am - 12:30 pm (EST)

Where
The Westin Cincinnati Hotel
21 East 5th Street
Cincinnati, OH 45202
(513) 621-7700

Seattle, WA
Thursday, October 1


Register Now

Time
9:00 am - 12:30 pm (PST)

Where
Seattle Plaza Building
Adobe Systems Incorporated
701 North 34th Street
Seattle, WA 98103
(206) 675-7000


San Francisco, CA
Friday, October 2


Register Now

Time
9:00 am - 12:30 pm (PST)

Where
Adobe Systems Incorporated
601 Townsend Street
San Francisco, CA 94103
(415) 832-2000

Can't make it? We have seventeen, on-demand eSeminars you can watch whenever you want!


Read on for a full agenda and details.

Documents submitted to the FDA's CBER and CDER must comply with the agency's PDF specifications regarding link appearance.

Both agencies prefer blue text for hyperlinks in PDFs created from electronic source files. For scanned documents, hyperlinks should be a thin blue line.

Electronic Source File
Pic showing a link in a PDF from an electronic source.
Scanned File
Pic showing a link on a scanned PDF

If you are creating documents in Microsoft Word, it is best to style the text blue, or edit your styles to include the color, then convert to PDF.

Regulatory professionals often have to work with scanned documents, or PDFs authored outside of their control. For these documents, a post-process is required to bring link appearance into compliancy.

In this article, I'll discuss how to change link color and style.

I recently received the following inquiries from customers::

Some of my Excel files contain more than  one worksheet. I would like to convert the second worksheet in an Excel file to the same PDF.

I have over 1000 Excel documents to convert to PDF as part of a regulatory filing. Is there a way to convert these all to PDF in batch?

I'll tackle both of these needs in this article.

Converting Multiple Worksheets

Fortunately, Acrobat 8 and later can easily convert all of the worksheets in your Excel files to PDF:

Excel file with multiple worksheets

When you use the PDF Maker in Acrobat 9, you have some additional options to select just the worksheets needed:

Excel conversion window in Acrobat

A) Choose options to convert all worksheets, the currently selected worksheet or a subset of the worksheets.

B) To choose some worksheets, but not others, select from the list on the left and use the Add or Remove buttons to move them to the list on the right.

C) Click the Convert to PDF button to complete the process

The result is a nicely bookmarked PDF that looks like this:

A nicely bookmarked PDF created from Excel

What about batch conversion?

If you want to convert many Excel documents in batch to PDF, there are a few additional tricks involved. Read on learn how in the rest of the article.

The pharmaceutical industry uses a lot of data. Consequently, we see a lot of tabular data converted to PDF documents. It is common to see lab instrument data, database reports and enterprise systems data output as PDF.

So, there you are, alone in your office staring at a PDF document wishing you had access to the original data. What do you do?

Fortunately, Acrobat 9.1 offers a couple of different ways to export to Excel.

  1. Select table and open in Excel
    This allows you to select a portion of a page and open it in Excel.

  2. Export as Tables in Excel
    This method uses some artificial intelligence to convert multiple page PDF documents to multiple worksheets in an XML-based spreadsheet file. It works best on files which were converted directly from Excel to PDF.

To open the XML-based file output generated using method 2 above, you'll need either:


Acrobat generally will usually do a pretty good job converting the text, but formatting and column widths will look different than the original. Acrobat only copies over the text. Formulas will not convert. Do not expect 100% fidelity.

In the full article, you'll receive my usual step-by-step instructions.