Can i print and make pdf at a time

gsrikanth · #1 06-05-2012, 10:41 PM

Can i print and make pdf at a time

our project whole on excel sheet i want make e-book, deliverable at the same time

macropod · #2 06-08-2012, 11:07 PM

If you're very quick ...

Of course, if you save to PDF, you can then print the PDF at your leisure.

gsrikanth · #3 06-08-2012, 11:11 PM

Quote:

Originally Posted by macropod

If you're very quick ...

Of course, if you save to PDF, you can then print the PDF at your leisure.

sir we have to gave many deliverables back by back (making page setup its it take age) we have no time to make e-book,
i.e., 100 page booklet relating to designs

macropod · #4 06-08-2012, 11:16 PM

You are not explaining the issue clearly. Excel can certainly create a PDF and print the file at essentially the same time. Even with a macro, though, one action must be done before the other. I cannot see what an e-book or the number of pages has to do with this. It doesn't matter whether you want to save to PDF or print - you'll still have to do your page setup and the more pages you have the longer that will take.

gsrikanth · #5 06-08-2012, 11:19 PM

Quote:

Originally Posted by macropod

You are not explaining the issue clearly. Excel can certainly create a PDF and print the file at essentially the same time. Even with a macro, though, one action must be done before the other. I cannot see what an e-book or the number of pages has to do with this. It doesn't matter whether you want to save to PDF or print - you'll still have to do your page setup and the more pages you have the longer that will take.

first time i have to select PRINTER
second time i have to select ADOBE

i need essetially the same time, i need that macro
do one after other

macropod · #6 06-09-2012, 12:05 AM

You could do that with a macro like:

Code:

Sub Demo()
ActiveSheet.PrintOut
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Split(ActiveWorkbook.Name, ".")(0)
End Sub

gsrikanth · #7 06-09-2012, 12:29 AM

Quote:

Originally Posted by macropod

You could do that with a macro like:

Code:

Sub Demo()
ActiveSheet.PrintOut
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Split(ActiveWorkbook.Name, ".")(0)
End Sub

print is comming
but pdf not preparing
where is the path of pdf will store?

macropod · #8 06-09-2012, 08:14 PM

The PDF will be saved at whatever your default save location is for Excel. If you want to change it to the same folder as the workbook, change:
ActiveWorkbook.Name
to:
ActiveWorkbook.FullName

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in	tinfanide	Excel Programming	1	03-04-2012 12:05 AM
Possible: Make default print one page?	lone road	Excel	0	01-10-2012 09:47 PM
Why the print preview is different from the editing view when we use the “make Entry”	Jamal NUMAN	Word	2	01-06-2011 02:44 PM
how to make the task starts next day if no time enough today(task can not be split)	duraid	Project	1	10-25-2010 08:31 AM
First Time Poster (How to make table of contents into Links)	enderzshadow	Word	2	02-21-2010 07:22 PM