Fragment Files

[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

[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