Can i print and make pdf at a time

macropod · #1 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 · #2 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?

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