Hi there,
can anyone help I'm stock here with a VBA problem (I think )
see code below, what I want to do is that Cell H2 what contains =now() to be saved as file name.
but its not working, is this the correct way or is there another way???
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"C:\user\documents" & Range("H2").Value = Now & "_" & "Pakbon" & ".pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub
Greetings,
STEEL010
can anyone help I'm stock here with a VBA problem (I think )
see code below, what I want to do is that Cell H2 what contains =now() to be saved as file name.
but its not working, is this the correct way or is there another way???
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"C:\user\documents" & Range("H2").Value = Now & "_" & "Pakbon" & ".pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub
Greetings,
STEEL010