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?