Merge two PDFs.

[EnG_TeLeCoMm]

Ladies \Gents...

I have an excel sheet, I need to attach PDF documents to it in the certain cell. no preview is required.
then I need to convert excel sheet(which contains PDF attachment) into one PDF file. So, when I open it I will see (excel sheet converted to pdf) and the attachment (in pdf) as a one pdf document

Can I have VBA code for that? Thanks in advance.


I posted the same question on excel forum with no luck, check below link.

Merge two pdf's.

 

[mole999]

there is a recent post with answer about merging pdfs on here, have a search around

 

[EnG_TeLeCoMm]

there is a recent post with answer about merging pdfs on here, have a search around

thanks sir for reference.

but my case is totally different.

I have one sheet contains sheet1,2,3,4 and sheet5.

I need to export all those sheets in one pdf (merged).

I could not tweak the code you referred to, so please help.

regards.

PS:-
my sheets(1,2,3,4 and sheet5) start from A1 to AG

 

[EnG_TeLeCoMm]

not forget to mention, I am using Foxit PhantomPDF, not adobe acrobat