#ExcelToPDFConverter #FileSystemObject #VBA
Hello Friends,
In this video you will learn how to create an Excel to PDF converter using VBA. This converter can convert multiple Excel file into PDF on single click.
Please download this excel file (Converter) from below given link:

See our Excel Products:

Visit to learn more:
Chart and Visualizations:
VBA Course:
Download useful Templates:
Dashboards:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

Nguồn: https://vmmotorsdaihan.com

Xem thêm bài viết khác: https://vmmotorsdaihan.com/tong-hop/

29 Comments

John Freedom Jones

June 18, 2020

Runtime error 424, object required, Debug says something is wrong with the section Set wb = Workbook.open (f.Path)

Reply

payal sharma

June 18, 2020

I have face one problem after the process complete . Word file in which 05 pages converted into 01 p df file . i want separate pdf file for all 05 pages .
Can you suggest me what i mistake do?

Reply

Luke Earthwalker

June 18, 2020

Hello Macro is working great, but is there any possibility to select area of cells to be put in the pdf file? I would like excel to automatically adjust the size of it so the pdf files look clear.

Reply

Ujjwal Tayal

June 18, 2020

It's irritating me.
So many problems orrured. After dealing with 7-8 dub errors when I finally able to successfully save the file, it was lost . I don't know where the pdf and excel gone.

Reply

Fortin James

June 18, 2020

Many thanks

Reply

Namrata Ghag

June 18, 2020

getting runtime error 5
Kindly suggest what can be the issue

Reply

Gaganpreet Singh

June 18, 2020

debug error in
sh= thisworkbook.sheets("sheet1")
microsoft scripting is turned on already
plz plz hlp

Reply

Karuppusamy N

June 18, 2020

Sir,
How to create monthly time sheet report to the specific employees with specific date from the database like print export. I hope you. Kindly provide the solution.

Reply

Shivam Verma

June 18, 2020

can i convert pdf to image(jpg)?

Reply

tommy tavarez

June 18, 2020

Excellent!

Reply

Ramadas Mullurkara

June 18, 2020

Can I convert entire workbook to PDF

Reply

Ashwin Kumar

June 18, 2020

Hi Sir,

Your teaching techniques are awesome , i am pretty impress.

I want a tool which converts all the ".JPG, .TIFF and other files into " .PDF" format. Could you please suggest me on this.

And my second question is can we combine the files and separate the PDF in VBA.

Thank you sir, waiting for your response.

Best Regards,

Ashwin Kumar

Reply

ORANGE PICTURES

June 18, 2020

Hi sir….. Super videos… Real hero. I like❤ your videos so much. It helped me a lot to improve my skills. Sir please make a video to convert pdf to excel using vba…. For each pdf in seperate sheet or excel

Reply

Nitish Sharma

June 18, 2020

Hi, Is it possible that all Excel file convert into PDF with password.

Or we can set a reference for the password.

Reply

CHANDAKA ASHOK

June 18, 2020

Brother, can you please share the code to convert an image into pdf

Reply

kurban ali

June 18, 2020

Hi sir
Is it possible to convert selected area to PDF from Excel.

Reply

Vishal Singh

June 18, 2020

I have issue in code
Run time error 13
type mismatch

Pls call 8010897905

Reply

raze2699

June 18, 2020

Great and excellent video.
Is there any code available where we can convert multiple sheets in same workbook into multiple pdf files.??

Thanks in Advance

Reply

Nishant Kotak

June 18, 2020

Hi thanks for the video!! It is very helpful.

Can you show an alternative to convert a single excel file with multiple tabs in to a pdf.

Thanks in advance and best regards
Nishant

Reply

Mohd Sartaj

June 18, 2020

Amazing

Reply

Jhon Cuellar

June 18, 2020

Amigo pk una pregunta: tienes algún ejemplo de trabajar un archivo de Excel con login para varios usuarios?… Y que se muestre la hoja del usuario que ingresa?… Te go inconvenientes cuando comparto el archivo porque solamente permite el ingreso al primer usuario que ingresa y el resto pueden abrir el archivo en modo lectura. Agradezco tu amable apoyo.

Reply

Sujeet Kumar Dutta Gupta

June 18, 2020

Sir awesome file but pls help how to convert pdf to excel…

Reply

Hariom Gupta

June 18, 2020

Sir plzz Help How convert scan document(pdf) to editable pdf

Reply

Manikanda Prabhu N

June 18, 2020

Hi sir! Can you please share Excel sheets merger in vba?

Reply

Satish Kumar

June 18, 2020

Awesome PK… yet another brilliant excel vba utility features…Well explained!!👍

Reply

Shwet Patel

June 18, 2020

Great..
But can you make a video or give a code for how to create automation certificate with single click create multiple certificate PDF like this given link video.
https://youtu.be/L3Hh2SVjBD4
Thanks in Advance.

Reply

aquayum72

June 18, 2020

Great video for short cut to PDF's

Reply

Patrik do N. Asensi

June 18, 2020

Tks! You can teach us how to make pdf > excel ?

Reply

TheExcelStudio

June 18, 2020

Great video!
Thanks.
Is there possibialty to convert to PDF with digital signeture via SELFCERT (Microsoft self digital signeture)?

Reply

Leave a Reply