Thanks, but For "Rename File" I colud not be saved as PDF Please, find the error I am sending you VBA Code recorded by Macro Sub SavePDF() ' ' SavePDF Macro ' ' ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "E:\E-Folder\New Formats\New Formats for New Company in Excel\Consumable items\Inventory for Arb Tower\Purchase Inventory BACKUP\" & Sheets("Inventory for Purchase").Range("b2").Value _ , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=True End Sub
Perfect, yes me resolved the problem, which was in Range Cell selection.
Thanks & Regards,
Tahir
Thank you so much sir it's to much help full sir ☺️😊
All the best
thank you brother......this is exactly what i wanted to lessen my task
Exellent Teaching Sir Shahab
Nice teaching
Excellent video very usefull
It is real helpful.
But I'm not able to save selection from sheet as followed your steps
Thanks for the video, I am able to do the same steps but with that button is also printed in PDF, how can I remove that
Select the print area
Thanks Sir, i want my file name combination of Invoice number and customer name, how to write range both cell name❓
Page 2 kiyu aa rahe hain bhai wo button ka print lena zaroori hai koya
I have windows 7 and the problem is pdf option is not available ..can u plss help me
Thanks, but For "Rename File" I colud not be saved as PDF
Please, find the error I am sending you VBA Code recorded by Macro
Sub SavePDF()
'
' SavePDF Macro
'
'
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"E:\E-Folder\New Formats\New Formats for New Company in Excel\Consumable items\Inventory for Arb Tower\Purchase Inventory BACKUP\" & Sheets("Inventory for Purchase").Range("b2").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub
Muje loop mai chahiye sir, muje last 1 year ka each day ka pdf mai banana hai Plz help
Can we make PDF uneditable ...???
Sar Aisa Hi Mujhe GST bill banana hai please help kar do na sir
Excel to PDF can vat Karne keliye net kajorurihe
Runtime error 9 sir ??
Salam sir ap apna Watsapp number ya email dalo MA ayk sheet bajonga Daily sell ka os ka tareka ap batwo oky ye Mara email Ha.....zk5031800@gmail.com