Hi,
I have made a macro which write all sheets into one pdf (see below). However, in some of the sheets I have also some objects (PDF). How can I write the sheets and the objects into one PDF?
Sub MakePDF()
'
' MAKEPDF Macro
'
'
ChDir "Z:\Finans\Regnskap\Avstemminger"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, filename:= _
"Z:\Finans\Regnskap\Avstemminger\Avstemming.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=Flase
End Sub
I have made a macro which write all sheets into one pdf (see below). However, in some of the sheets I have also some objects (PDF). How can I write the sheets and the objects into one PDF?
Sub MakePDF()
'
' MAKEPDF Macro
'
'
ChDir "Z:\Finans\Regnskap\Avstemminger"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, filename:= _
"Z:\Finans\Regnskap\Avstemminger\Avstemming.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=Flase
End Sub