How to Save Each Invoice in PDF Automatically | Microsoft Excel Tutorial in Hindi

Doston is video mein maine apko bataya hai ki kis tarah hum microsoft excel mein banaye gaye invoice or Bill ko autosave kar sakte hai PDF Format mein. Iske liye humne use kiya hai ek excel macro or VBA code ka jo hamare sabhi invoice ko PDF format mein save karne mein hamari madad karta hai. Is macro or VBA code ko download karne ke liye aap niche diye gaye link par click karke ise download kar sakte hain. Ye macro excel ke sabhi format mein kaam karega jaise ki, MS Excel 2007, Ms excel 2010, excel 2013, ms excel 2019. Hope aap sabko hamara ye video pasand aayega.
👉Get Our Complete Excel Course Now - www.mylivesupp...
👉Subscribe Our New Channel - bit.ly/2JeYnM7
Download Excel Invoice Format - Download Invoice Format - drive.google.c...
Download Coding File for Practice - drive.google.c...
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate • Make Fully Automatic G...
Your Queries :
1) How to Save Every Excel Invoice or Bill in PDF Automatically
2) How to Store each MS Excel Invoice or Bill in PDF format using VBA code
3) How to Take backup of all excel Invoice or Bill in PDF format automatic
4) How to Auto Save Each Excel Invoice or Bill in PDF
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook - / mylivesupport
Website - mylivesupport.in/
Follow us on Twitter - / mylivesupport
Follow us Instagram - / mylivesupport
Facebook Myself - / chandankumar926
TH-cam - / mylivesupport
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
▶️All Advanced Excel Video in Hindi - bit.ly/2Ej6Viy
▶️All Computer Tips and Tricks Video in Hindi - bit.ly/2Pj70Ji
▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
▶️All Videos of Excel in Hindi - goo.gl/boUo8C
▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
#excel #AutoSaveinPDF #invoice #excelVBA #msexcel #exceltutorialinhindi #tips #tricks #mylivesupport
Most Useful Videos of Our Channel - Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial • How to Convert Handwri...
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi • How to Maintain Attend...
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥 • 🔥How to Recover Unsave...
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert • Excel में किसी भी Shee...
▶️Ms Word में Expert बनना है तो इन 5 Magical Tricks का USE करना सीखलो • Ms Word में Expert बनन...
▶️Excel की इन 20 Shortcut Key का Use करना सीख लो | Become Excel Expert | My Live Support • Excel की इन 20 Shortcu...
▶️ऑफिस में बनना है सबसे Smart तो MS Word की इन 20 Magical Tricks का Use करना सीखलो • ऑफिस में बनना है सबसे ...
▶️4 Super Cool Tricks for MS Excel | Excel Magic Trick Part 13 • 4 Super Cool Tricks fo...
▶️बॉस को करना है Impress तो Excel में ये 4 Super Tricks जरुर सीखें | Excel Magic Tricks Part 6 • बॉस को करना है Impress...
▶️How to Convert any Image to Excel | MS Excel New Feature Tutorial in Hindi • How to Convert any Ima...
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
---------------- Chandan Kumar ----------------

[@abhishekcreation4011]

Thank you sir aap hame free me itne usefull information 🙏 dete hai🙏🙏

[@MyLiveSupport]

Thank you so much 😀🤗🤩

[@bantiyadav4633]

Thanks u so much is video ke liye aap ne mera kam bhot aasan kr diya

[@yogeshsakhalkaracademy18]

Hi sir bahot hi saral tech. Se aapne samzaya hai sir thank u

[@sachhai008]

App se achh koi bhi nahi bata sakta hai

[@alfaenglishacademy4084]

Thank you so much bhai ..you are good and gentle man

[@TanRisa2014]

I need more knowledge Thank you sooooo much

[@nimokumar7443]

Thanks sir ek bahut hi achha or useful idea dene ke liye

[@arunkumarsinghark3024]

बहुत अच्छा सर

[@moodkn]

Very Well... Excellent ... Appreciate You... Lot of Thanks!

[@vipulshah7306]

Vow Nice. So Much Useful.

[@sdpvlogs437]

Thank you bade bhaiiiya

[@ayushtyagi9185]

It worked man!! Thank you for sharing this information.

[@lukendrasahu3742]

Very informative it helped me a lot thanks you so much 🤗🤗

[@asimsiddiq475]

very, very informative 4 us, to improve our skills in it, thanks a lot.

[@atulshukal4072]

Very good Sir

[@vishalbhati912]

really very helpful. thanku sir

[@legendff1512]

Very informative it helped me a lot thank you

[@dailyquranrecitationhd4509]

very nice

[@premkumarmsw5605]

Thanks bhaii

[@muhammadsohailkhan8451]

Thanks sir solve my problem

[@delhiganeshan]

amazing

[@udayam77]

Hi, xlxs format mein bhi save hoga at the same time?
Thank you.

[@sunilshrestha5662]

aap ne banaye huye invoice ka her details jo items sahit ka data kaise dusra sheet me transfer kar sakte hai with vba use karke

[@infotech1889]

Thanks

[@sangramsahoo767]

THANQ SO MUCH

[@amitjain-jainshreeassociat8827]

Very bioinformatic easy to understand. Thanks.
can this pdf command will use with new invoice as in your last video?
if we have more item then how can we continue the invoice means page 1, page 2 ....
how can we run this micro enable file.
Please reply

[@knowledgeoceanofficial4363]

Thanks a lot of thanks

[@ankitdeva5931]

Very good video sir

[@KingstocksAndQueenOptions]

Good

[@badripatra19]

Nice video 👍👍👍👌👌👌 👌

[@MyLiveSupport]

Thanks 😄🤗

[@MedievalArts007]

nice work

[@shaishavshah7759]

Informative video

[@MyLiveSupport]

Thanks 😄🤗🥰

[@kiranbandekar2434]

Sir ji , ye maine Kiya .. Sahi hai sir ji.. Mujhe Button sir ji Dusre sheet pe chahiye hi to kaise kare.. Jaise ki Invice sheet 3 me hai Button Sheet 1 pe Banana hai

[@mangalsamanta9227]

Sir how to create invoice data base folder ...jaha her ak invoice serial number ka hisab se serially save hote jayaga

[@viswanathancr2801]

good video

[@Maheshkumar-ru1yy]

Kya pdf banane k baad agr kuch edit karna ho to kya invoice ka ik pdf or bnyga kya sir pls

[@tallystudent9094]

Thank you Sir.. Sir, agar multiple workbook ke invoice ko ekhi workbook mai kaise transfer kar skte hai without doing multiple time copy past...

[@rajankukreja8203]

Thank you sir for a helpful video. I am having an issue with the vba coding. When I am applying this coding to my file the buttons are also showing on the second page of pdf which i dont want how to edit this. Pls specify. Thanks

[@rakeshinfotech7296]

गुड सर
Aapka fun

[@MyLiveSupport]

Thank you

[@aap9098]

vry nice sir🙏🙏🙏🙏

[@muawiaanas4691]

us men result card fee etc all of codes dedent videos k sath thanx

[@shariquejaved2934]

Good one but mujhe ye bataye ki agar Invoice number normal digot me nahi hai, mixed hai tab kya ye pdf me save karega?

[@MyLiveSupport]

Yes

[@shariquejaved2934]

@@MyLiveSupport kaise?? how?? Lets suppose the invoice number is NBB/APL/EW/100-20
Ye format me mujhe save krna hai

[@arunkumarsinghark3024]

Ms office ko pure tab तथा ब्लॉक wise video ki series banaye sir

[@MyLiveSupport]

Okay

[@behzadahmad1064]

Love you brother

[@MyLiveSupport]

🤗🥰💐

[@tausifnedarya5851]

Thanks Sir, i want my file name combination of Invoice number and customer name, in this case how to write range❓

[@ajayvermavadodara8762]

Very useful

[@MyLiveSupport]

Thanks 🥰

[@devendrakarwadkar4970]

sir ishi Code mey muje party name and ivoice numbr dono chayeah tau hum kaisey kare code me changes

[@Mehta._.Jasmin]

Same bhai muje bhi dono chahiye

[@Mehta._.Jasmin]

Aur mere to 2 page pdf me save ho rahe hai

[@152207vijay]

bilkul sahi hai ji lekin as itis save ho jata hai with formula aisa koi upaye hai ki copy ho jaye par formula copy na ho

[@UMESHKUMAR-tz6ws]

HI Sir thanks for this video, i have one issue save the invoice as pdf, the file save in 6 page, i need only 1 page pdf invoice file

[@MyLiveSupport]

Set print area

[@9821399236]

How to set print area sir

[@9821399236]

Hi sir...did you get the sollution

[@bushrasiddique4490]

अगर invoice no और party name मिलाकर लिखना हो , जैसे 53 Arun Chemicals तो vba code किसतरह लिखें..!!?

[@RakeshKumar-qd3ix]

Nice, Thank u sir, sir ismei file ko protect aur formulas hide kar rha tha to lag nhi rha thaa iska koi solutions btao sir

[@MyLiveSupport]

Already ek video banaya hai channel par mil jayega

[@vaibhavbhagat254]

sir agar hame invoice mai kuch change karna ho, to kaise kare, pdf file bana to
agar aage jake price list change hua to invoice bhi change ho jayega already save wala agar excel mai ho,, to kya kare

[@arunkumarsinghark3024]

🌹🔥 राधे राधे🔥ARK🌹🏹

[@paramjeet975singh3]

sir ek bat samaj ni aati ye vba code mai kya kya likhna padta hai ye kaise pata chalega, abi to copy kar lege magar ye ni pata chal paa raha hai ki likhna kya kya hai isme ......plssss vba basic se kara diziye ??

[@nitinjethava]

Thanks i make invoice but error is merge cell issue how to solve please help

[@jasmeetsinghsaluja7390]

Sir kya invoice number or customer name dono ke sath save kia ja skta hai..??
Like ..
Invoice Number - Customer Name
"39 - Ramesh Traders"

[@saiffister]

Sir please Invoice modify karne ki querry bataye

[@musebshaikh7617]

Invoice No=01
Now suppose I am working for January.
then I need my invoice Number to increase by 1
after that if the month changes to February
then again my invoice Number should start from 1 and get increase by 1 for each new invoice.
It should follow the same every time the month get's changed.
what is the possible vba code for this.
please reply

[@munnapanjvani5844]

hello sir mene video dekha apka aur mene try bhi kiya super video hai sir bt ek problem hai jab me PDF banata hu to sheet me jo jo tipe kiya hota hai sab ki PDF banti hai nahi k khali invoice to only invoice ko hi PDF banana hai to kya kare plz sir gued karo.

[@zd.zahid001]

Sir jab hum invoice save kare to serial numbers and Clint name bhi dono se invoice save ho kya kare please

[@sachhai008]

Hi sir ab itna bata diye hai to ye bhi bata dijiye ki ek hi switch click karne se PDF file bhi ban jaye aor DTA SAVE bhi ho jaye aor PRINT bhi ho jaye please sir I humble Request sir🙏🙏🙏🙏🙏

[@nimokumar7443]

Or Sath me print area bhi

[@SatishGupta-eh8vg]

Sir thanks you code very help full for me ,but 1 problem is that it work only one time in macron ,when I close tha tha Ms Excel then the macron code is erase so how it can be solve please help

[@SatishGupta-eh8vg]

Please give me solution for this problem 🙏

[@sachinram72]

Sir thanks for the information
Sir i have a one problem if i click on SAVE button showing Run time error 1004 please help me sir

[@javedmansoori6392]

Same problem

[@sandhyarawat1768]

Sir, agar kisi ko macro enable file send karni hai to kaise bheje...kyu ki kabhi kabhi send karne k baad error dikhata hai sender k PC me ...plz reply

[@riyazkhan-yf5to]

Sir when I am saving invoice in the name of xyz company its save but when next invoice is not saving in same xyz company name
Thanks

[@imthusan]

bhai saab, kiyaa aap doctor daily check up with each patient discussion form bana sakthaho, is pay aap video banao,patient ka naam laikay , ya dob lay kay, ek patient ka uska visitng date laykaym, kiya discussion hotha doctor kay saath , aisay may ek badiyaa video banao sir, jub bee patient visit kartha hai usdin jo doctor discuss karttha hai , kay wo is ka poori record datewise visiting details mainatain karay aisa may saari jees aani jaye,aisay pe video bano brother urgently

[@SkillKnowledge]

Ok

[@imthusan]

@@SkillKnowledge aap samajgaye kiya

[@arvindmevalaljaiswal7234]

Sir Hame Party Name Aur Invoice No. Dono Ke Sath Save Karna Hai To Kya Karna Hai. Please Bataye. (Name Aur Invoice No. Alag-Alag Cell Me Hai).

[@ravigahlot179]

Kindly provide how to print large ( wide) text file into one page

[@BekindUdaipur]

Invalid procedure call or argument, run time error 5, code is written as it is only path is exchanged, Please explain

[@citycomputer5120]

Hi sir main jab save pdf krta ho to error no '5' aa jata hy kindly help me for this error. Thanks

[@68team]

Please help!!!👏👏
Sir agar mujhe yahi file exel format me bhi save krni hai to kya kre.
Please help friends...

[@neerajgaur6723]

सर , मैंने आपकी विडियो देखि बहुत आछी लगी मैंने एक्सेल में काम भी किया किन्तु एक्सेल में सेव तो हो रही किन्तु फोल्डर में नहीं जा रही है न ही document में बिल नो. से सेव हो रही है कृपया मदद करे ! धन्यवाद

[@sumanpaul1948]

if there is same file exists, what happen?? it automatically replace... but I want to save as new file name....can you help me by solving this.....??

[@srikanthbvo7365]

sir, i m getting runtime error 's', invalid procedure call or argument error message.....what to do??

[@rajkumarpaul8598]

Same

[@rajendraprasadkuda2536]

can I use this in 2007

[@rajeshshah6758]

Sir, code file kaam nahi kar raha. Is Line mein mistake hai to correct karne ke salah de
Sub SaveInvoiceAsPDFandClear()
Dim NewFN As Variant
NewFN = "C:\Users\Admin\Desktop\Rajesh\grm invoice format\Invoice Data \" & Range("C9").Value & ".PDF"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=NewFN, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrinAreas:=False, openAfterPublish:=False
End Sub

[@shrutiiravati]

I am not able to create the Assign Micro on PDF Button, PDF file is not creating, showing Run Time error 5,

[@kiranbandekar2434]

sir ji pdf file pdf bhi likha huva second page pe aa raha hai.. usko kaise adjust kare

[@anjanikumar5992]

जब हम फार्मूला लगाते हैं और सीवेज पर क्लिक करते हैं runtime error a raha hai
यह प्रॉब्लम कैसे सॉल्व होगा

[@energy11000]

I am save both number and party name

[@riccardosimo94]

The only problem is that even if i change the destination folder it saves the pdf in documents... how can I fix it?

[@riyazkhan-yf5to]

Sir ek company save hone par wahi company dusi bar save nahi hoti hai invoice no. Main yah problem nahi ata haii

[@nakummaulik1972]

Error
because of your security setting,macros have been disabled,to run macros ,you need to reopen this workbook ,and then choose to enable macros.for more information about enbling macros,

[@nakummaulik1972]

Es error kese sol karu sir ji

[@jxccreationunboxing9629]

sir CGST Aur SGST Kaise banaye

[@Khotey7400]

Sir i am facing some problems for doing this. I find run time error 5 when i coding

[@arvindkumar2178]

Run time error '1004':
Document not saved. The document may be oepn, or an error may have been encountered when saying
Plz resolve Sir

[@mdirfanahmed190]

Sir invoice number aur customer name 2 save karna Raha to kaise kare

[@tabrezhussain4291]

How to download VBA code it getting error for me

[@aaniyadav5557]

Name or invoice no. Dono se kese save kare plz bata dijiye

[@ravikhande1546]

Can we make PDF uneditable ...???

[@BharatKumar-fh7ei]

How to save invoice by Invoice No and customer name both together.

[@3phgreeneergypvtltd550]

i am getting this error vba code is not functioning,Sub SaveInvoiceAsPDFAndClear()
Dim NewFN As Variant
NewFN = "C:\Users\Admin\Documents\TEST GST INVOICE IN EXCEL\CUSTOMER INVOICE IN PDF\" & Range("n12").Value & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=NewFN, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub

[@snvrisk786]

pdf me 2 page ate hai button bhi dikh raha hai pdf me

[@muawiaanas4691]

school manage ment ka bhejen

[@rahulnaskar8356]

Run time error 5.
Invalid procedure call or argument. Dekharaha hay

[@Sanjeevdehrian]

Kya mail bhi ho skti h iski

[@wavetele87]

how to write total SUM in words

[@baijukumar9949]

i cannot saved it. shows as runtime error 5

[@Brooktaube]

Run time - error '5' show ho rha hai

[@prempatel3713]

Mene pura video dekha sath sath me try Kiya nahi hota hai