Good Sharing Sir I am making 6 Sheets to PDF on a single button but 2 Sheets are on Pivot Table & 1 Sheet is daily data Sheet & 3 Sheets are on fixed range so whenever I make PDF 1st I have to change range of 3 Sheets then I convert in VBA. Can you suggest me If my rows will increase so how can I set auto range on VBA for Pivot Table and as well as Simple Daily data Sheet (Without Pivot Table). Then it automatically change range of ROWS Thanks
@@ExcelDestination can you share the code for below file path: [[ActiveSheet.Range("A1:O102").ExportAsFixedFormat xlTypePDF, FileName:="C:\Levi's Recipe\" & ActiveSheet.Range("P1").Value, openafterpublish:=True]]
My excel file has 1 sheet, including 2 pages. I need you to support vba code to create 2 PDF files, each page is a PDF file, save the resulting file in In addition, there are other similar cases such as: 1/ All sheets 2/ Select any number of Sheets Have a nice day
Thanks so much. I was not able to change folders to desktop or anywhere else but I can live with that :)
Thank you great video
Very nice tutorial. I did some modifications to this to select any file using open dialog and convert it to PDF
Great 👍
Hi Sir , can you teach us a vba on sampling selection for auditing purposes.
Thank you for the excellent video. : ) May I check how to save as encrypted pdf with password and restrict editing? Thank you
is it possible to just open that info from the Excel in a PDF file and then if I want save it to desktop?
You’re amazing! Thank you!
Hi, Can you safe the pdf as it were printed as in Microsoft Edge?
Does not work if the sheet contains more than 1 page in the print area... please help with this issue.
how can I send all the pdf I saved in a path via IBM notes mail
What if I want to save a specific cell as pdf and I want to set its location to the current excel file location. How?
It would require different VBA Code, but it is very much possible.
@@ExcelDestination Can you help me with that?
Can you send me your excel file and specify cell also, you want to save as pdf..........my email address is EXCELDESTINATION@GMAIL.COM
Good Sharing Sir
I am making 6 Sheets to PDF on a single button but 2 Sheets are on Pivot Table & 1 Sheet is daily data Sheet & 3 Sheets are on fixed range so whenever I make PDF 1st I have to change range of 3 Sheets then I convert in VBA.
Can you suggest me If my rows will increase so how can I set auto range on VBA for Pivot Table and as well as Simple Daily data Sheet (Without Pivot Table).
Then it automatically change range of ROWS
Thanks
Great 👍
How to dwnld ur vba code
sir, that vba code will work on office 2010? kindly reply
Yes it will
@@ExcelDestination but not working for me ..am using office 2010 ...what can I do.. kindly reply sir
how to write a VBA script for more than one excel file convert to PDF?
you can use looping statement
Getting runtime error 5 while playing Macro
Pls check your code again. If it doesn't get fixed, send me your file at exceldestination@gmail.com
HOW TO PASSWORD PROTACTE
but if I save same file then I want to rename automatically.... is it possible???
Yes it is very much possible.
@@ExcelDestination can you share the code for below file path: [[ActiveSheet.Range("A1:O102").ExportAsFixedFormat xlTypePDF, FileName:="C:\Levi's Recipe\" & ActiveSheet.Range("P1").Value, openafterpublish:=True]]
Good but how to save all the sheets in a single PDF file?
please ......can add header to pdf
yes we can add header I would suggest to add header in excel itself and print as pdf.
I want to save multiple sheets into one PDF using command button. Please send VBA code.
Can we make PDF uneditable ...???
not sure
how to save all tabs in one pdf?
there would be additional code required. If you need VBA Help, you can send me email at exceldestination@gmail.com
I'm sorry same question again. Can you please upload a Google drive link for that additional code? So that everyone can see that. Thanks in advance
Can you please put the code here in the comment? :(
My excel file has 1 sheet, including 2 pages. I need you to support vba code to create 2 PDF files, each page is a PDF file, save the resulting file in
In addition, there are other similar cases such as:
1/ All sheets
2/ Select any number of Sheets
Have a nice day
How to save without sheet 1
use if condition......like if activesheet.name"sheet1" then......
@@ExcelDestination I want to ignore sheet 1 from PDF savings only Jan Feb should be printed