Generate Multiple PDF's with the available data

[VinodKrishnappa]

Hi,
I would like to generate individual .pdf files by using a data available in excel. It's like using a employee ID as file name create pay slip in a particular format.

Please let me know if it can be done through macros,

Thanks in advance..

Kind Regards,
VK

 

[Takae]

This is sample code.

Sub Sample1()
Dim ID As String
Const path = "C:\Users\Desktop\"
ID = InputBox("employee ID ?")
    Sheets("sheet1").ExportAsFixedFormat Type:=xlTypePDF, _
    filename:=path & "_" & ID & "_" & Format(Date, "mmdd") & ".pdf", _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False
End Sub

 

[gselvam]

Hi Takae,

I would like to try your reply.
I have excel data
Now where i will appy your code ,
can you please provide me the steps.
I am sorry to ask steps as i am new to macros/advanced excel

Thanks

 

[Takae]

1. Open your new workbook.
2. Press the keys ALT + F11.
3. Press the keys ALT + I ,and press M(You cn see Standard Module).
4. Copy the code and paste the code to the new module.
5. Press the keys ALT + Q
6. Press ALT + F8 and double click the macro's name to Run it.
I hope this makes some sense.

 

[mzithoboss]

I have two seperate folders and want to create multiple pdf's
folder one has pdf1, pdf2, pdf3...
folder two has pdf1, pdf2, pdf3...
a new pdf must be created taking pdf1 from both folders and name this as the new pdf1