Fragment Files

R

RohanSewgobind

Hello Everyone,

My name is Rohan Sewgobind. I recently attended the Excel User
conference in Atlantic City and would like to take a moment to thank
all of the presenters for their useful tips and examples.
Now the question
I work for Weill Cornell Physician Organization where we rely heavily
of pdf files that we create by printing excel files using Adobe PDF
Writer. Is there a way to stop the creation of the 0kb fragment
files?

Thanks in Advance,
Rohan Sewgobind
 
D

damorrison

How are you printing the PDF file
I have tried many ways to get it to print in one file, instead of many,
I have learned to create a macro that hides the sheets that do not
require printing, something like,

Sub PrintSelectSheets()
Application.ScreenUpdating = False
'Print One
Sheets("Select").Select
If ActiveSheet.Range("F4").Value < 1 Then
Sheets("one").Select
ActiveWindow.SelectedSheets.Visible = False
End If
'print two
Sheets("Select").Select
If ActiveSheet.Range("F5").Value < 1 Then
Sheets("two").Select
ActiveWindow.SelectedSheets.Visible = False
..
..
..
..
..
'Print workbook
Application.ActivePrinter = "PDF reDirect v2 on Ne00:"
ActiveWorkbook.PrintOut Copies:=1, ActivePrinter:= _
"PDF reDirect v2 on Ne00:", Collate:=True
'unhide sheets
Sheets("one").Visible = True
Sheets("two").Visible = True

End Sub

Once all the appropriate sheets are hidden , the macro tells excel to
print the entire workbook in PDF and therefore only get one pdf file

I have seen other examples, this one seems to work best for me

Hope this is what you were asking

There are also forums that are dedicated to your PDF program
 
Top