VBA button excel to pdf.

[@YogeshSharma-ui7xx]

Wonderful illustration to the specific point without wasting any single second as all others youtubers do. Thanks it all works perfectly

[@jimmywalker8943]

Is your invoice example the result of a pivot table ? And can you run the macro outside of excel ?

[@russellporter7952]

@pj-excel, is there a way of selecting 2 cells as the save title? On mine I want a customer and date. So would need cells A3 & H3 as the range

[@AmeerHamza-io9ik]

Fabulous Work. I found it very helping. It will solve majority of my problems

[@jayaprakash5009]

@AmeerHamza-io9ik

[@Jordannahuwo622]

Is it possible print drop down list (validated data) to a single pdf file ?

[@Giovanni-vx8xl]

would be possible to create one so other users can use it too? now I m the only one who can use it.

[@kashidkhan2092]

How did u copied cell reference and paste it into Module?

[@nikdrenski3003]

This is a great tutorial... Im looking to take this one step further, by having the folder name change based on a cell value. Is this possible?

[@pj-excel]

At the code add commands to create folders: Dim fn As String fn = Sheets("sheet1").Range("F3").Value MkDir "C:\Users\Asus\Documents\" & fn

[@pj-excel]

Then at the 2.42 minute clip, change the code to "C:\Users\Asus\Documents\" & fn & "\" & Sheets("sheet1").Range("F3").Value

[@nikdrenski3003]

@@pj-excel You're a Legend! Keep up the good work

[@shivanimahida5544]

​@@pj-excelhey PJ would you be able to help me on this please?

[@ravikhande1546]

Can we make PDF uneditable ...???

[@ranjith91221]

Its creating another page with make to pdf button on it. How to get only the sheet?

[@umar32bright]

Sir i have an error when i press save button. Run time error '424':

[@fakhrulparvez]

Where I will save the Excel file????? Thanks in advance

[@alphabeta9032]

Thank you Very much. Made my work much easy :)

[@joeydominicus4284]

hii, i can not fix the thing that its going to safe as a cell name.. can u help me with that?

[@mustafa1146.]

The best video i have ever seen ;)

[@Derek5920]

Nice thanks for sharing

[@qwertypad8480]

Hello i copied the Excel file to another pc, it gives me an error and cannot genrate pdf

[@kasparspiternieks5742]

Whats the text that shold be copied in macross, its not working if I write it... :(

[@pj-excel]

How is the performance?

[@pj-excel]

How is the performance?

[@zainalabidinabubakar207]

firstly thank you for your generous simply tutorial video. what if i would like to create a macro, similar to this but with the control of the destination folder ? like when i click the button, it would come out a 'save as' pop up ?

[@zainalabidinabubakar207]

or perhaps to be able to save in folder which is named based on the case number?

[@DashrathSangle]

@@zainalabidinabubakar207 Yes I was looking for same, did you get the solution?

[@nirajsingh2241]

It is works 2007 or not...

[@priyanthagamini3860]

Excellent work

[@MuhammadKamran-tu9di]

Hi, you shown good demonstration in video but I will request you to please mention all video "TITLES" in English as well because we can not trace the videos in your language.

[@OwenKing-n7h]

Does anyone know how you can update the Macro to save the file name as the invoice number on a Mac? This macro works but the file name save does not seem to work on a Mac

[@factsincoming]

i cant find solution for this in months. did you find one?

[@gillesdevriendt9575]

Hello, Thank you very much for the tutorial, would anyone mind giving me some more explanation on how you can make sure that there is only 1 page in the PDF doc? Now I have my invoice on the first page and the "makepdf" button on the second. Thank you in advance!

[@drakwer25]

Great video! quick and hits all major points. Thank you!

[@pj-excel]

Guide: Org chart and image link in Excel kzbin.info/www/bejne/pYTYfq2LhKyhZ6s

[@QGinzo]

I used this expression as my file name and it's giving me errors, "& Sheets("Housing checks").Range("G4").Value, What could be the problem? Thanks in advance.

[@pj-excel]

Try checking the file name. Is equal to the information in the G4 of "Housing checks" sheet.

[@pj-excel]

Try to check that the storage is correct or not.

[@mybongblog725]

Many Many 👍Thanks

[@MustafaAhmed-mb7hu]

Gr8 work...excellent....How to define the printable area?

[@123totaly]

i have issue, error says document not saved how to resolve this

[@pj-excel]

Try to check that the storage is correct or not.

[@georgealoyce4849]

Nice video but to bad when i close my excel and reopen the button disappears, help me

[@pj-excel]

you must save as type Excel Macro - Enabled Workbook

[@SsTmoviess]

It's not working in office 2007

[@nancyali9456]

Need script to convert multiple cells into a filable PDF with a button

[@globallinksbd9924]

i didnt understand the f3 part

[@amanbaig9268]

Thank you boss

[@syedazharyoutube]

perfect tutorial

[@pj-excel]

THK. ^_^

[@pj-excel]

Guide: Org chart and image link in Excel kzbin.info/www/bejne/pYTYfq2LhKyhZ6s

[@rahuljangra5205]

its cool thanks

[@pj-excel]

Thk ^_^

[@pj-excel]

Guide: Org chart and image link in Excel kzbin.info/www/bejne/pYTYfq2LhKyhZ6s

[@rows_columns]

Good Job :)

[@rakibhasanantor4567]

Not working

[@deepshikhajaiswal7009]

how can I find file name based on F3, its not working

[@pj-excel]

Can find file at menu developer-visyal basic Or Can be viewed in clips at 2.27 minutes.

[@deepshikhajaiswal7009]

@@pj-excelI meant the sheet/cell name (in your file - it is Sheets("Invoice").Range("F3").Valve, how should I find my file name like this?

[@pj-excel]

The program will create a document according to the code in the clip. See 2.7 minutes. Follow the sample clip set at 2.55.

[@pj-excel]

Therefore, you can access the files in the folder C:\User\Asus\Documents\PDF\Invoice.pdf

[@pj-excel]

And can change the recording of the document by specifying the storage location as instructed in the clip at 2.55