Mohammad Shafaat
New Member
Hi team
Please help to any VBA code to save data Form as a PDF in one thread as per the EMP id Eg: Having 4 Accounts so Form showing in one PDF like Thread.
I m Using VBA code :
>>> use code - tags <<<
It saves individually PDF in the folder Required Employee wise PDF with Grouping in one
Thanks In Advance..
Please help to any VBA code to save data Form as a PDF in one thread as per the EMP id Eg: Having 4 Accounts so Form showing in one PDF like Thread.
I m Using VBA code :
>>> use code - tags <<<
Code:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("Retailer Dialogue-All retailers").Select
Range("g5").Select
Dim r As Range
For i = 2 To Sheets("Sheet1").Range("e2")
Sheets("Sheet1").Range("c" & i).Copy
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Sheets("Sheet1").Range("c" & i), Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False
Next
End Sub
Thanks In Advance..
Last edited by a moderator: