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
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
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
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 ??
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
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
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🙏🙏🙏🙏🙏
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
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
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,
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.
सर , मैंने आपकी विडियो देखि बहुत आछी लगी मैंने एक्सेल में काम भी किया किन्तु एक्सेल में सेव तो हो रही किन्तु फोल्डर में नहीं जा रही है न ही document में बिल नो. से सेव हो रही है कृपया मदद करे ! धन्यवाद
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
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
Hi sir bahot hi saral tech. Se aapne samzaya hai sir thank u
Thank you sir aap hame free me itne usefull information 🙏 dete hai🙏🙏
Thank you so much 😀🤗🤩
Thanks u so much is video ke liye aap ne mera kam bhot aasan kr diya
App se achh koi bhi nahi bata sakta hai
Thanks sir ek bahut hi achha or useful idea dene ke liye
Thank you so much bhai ..you are good and gentle man
I need more knowledge Thank you sooooo much
बहुत अच्छा सर
Very Well... Excellent ... Appreciate You... Lot of Thanks!
It worked man!! Thank you for sharing this information.
Very informative it helped me a lot thank you
Very informative it helped me a lot thanks you so much 🤗🤗
Vow Nice. So Much Useful.
Thank you bade bhaiiiya
Very good Sir
really very helpful. thanku sir
very, very informative 4 us, to improve our skills in it, thanks a lot.
Hi, xlxs format mein bhi save hoga at the same time?
Thank you.
Thanks sir solve my problem
गुड सर
Aapka fun
Thank you
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
Thank you Sir.. Sir, agar multiple workbook ke invoice ko ekhi workbook mai kaise transfer kar skte hai without doing multiple time copy past...
Informative video
Thanks 😄🤗🥰
very nice
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
nice work
Sir how to create invoice data base folder ...jaha her ak invoice serial number ka hisab se serially save hote jayaga
Very good video sir
sir ishi Code mey muje party name and ivoice numbr dono chayeah tau hum kaisey kare code me changes
Same bhai muje bhi dono chahiye
Aur mere to 2 page pdf me save ho rahe hai
Thanks Sir, i want my file name combination of Invoice number and customer name, in this case how to write range❓
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
Good
Nice video 👍👍👍👌👌👌 👌
Thanks 😄🤗
THANQ SO MUCH
amazing
Kya pdf banane k baad agr kuch edit karna ho to kya invoice ka ik pdf or bnyga kya sir pls
Thanks a lot of thanks
🌹🔥 राधे राधे🔥ARK🌹🏹
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
vry nice sir🙏🙏🙏🙏
Thanks bhaii
Thanks
Sir please Invoice modify karne ki querry bataye
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
Already ek video banaya hai channel par mil jayega
अगर invoice no और party name मिलाकर लिखना हो , जैसे 53 Arun Chemicals तो vba code किसतरह लिखें..!!?
good video
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
Set print area
How to set print area sir
Hi sir...did you get the sollution
Good one but mujhe ye bataye ki agar Invoice number normal digot me nahi hai, mixed hai tab kya ye pdf me save karega?
Yes
@@MyLiveSupport kaise?? how?? Lets suppose the invoice number is NBB/APL/EW/100-20
Ye format me mujhe save krna hai
Love you brother
🤗🥰💐
Very useful
Thanks 🥰
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 ??
Ms office ko pure tab तथा ब्लॉक wise video ki series banaye sir
Okay
us men result card fee etc all of codes dedent videos k sath thanx
Kindly provide how to print large ( wide) text file into one page
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
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).
Thanks i make invoice but error is merge cell issue how to solve please help
Sir kya invoice number or customer name dono ke sath save kia ja skta hai..??
Like ..
Invoice Number - Customer Name
"39 - Ramesh Traders"
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
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
Same problem
Sir jab hum invoice save kare to serial numbers and Clint name bhi dono se invoice save ho kya kare please
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
Please give me solution for this problem 🙏
sir CGST Aur SGST Kaise banaye
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🙏🙏🙏🙏🙏
Or Sath me print area bhi
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
sir, i m getting runtime error 's', invalid procedure call or argument error message.....what to do??
Same
Please help!!!👏👏
Sir agar mujhe yahi file exel format me bhi save krni hai to kya kre.
Please help friends...
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
Ok
@@SkillKnowledge aap samajgaye kiya
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.....??
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,
Es error kese sol karu sir ji
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
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
Invalid procedure call or argument, run time error 5, code is written as it is only path is exchanged, Please explain
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.
can I use this in 2007
Hi sir main jab save pdf krta ho to error no '5' aa jata hy kindly help me for this error. Thanks
Name or invoice no. Dono se kese save kare plz bata dijiye
How to save invoice by Invoice No and customer name both together.
Kya mail bhi ho skti h iski
I am save both number and party name
Once close file after open not working
Save in Excel macro enable workbook
I have also this problem how can it solve please tell me sir
जब हम फार्मूला लगाते हैं और सीवेज पर क्लिक करते हैं runtime error a raha hai
यह प्रॉब्लम कैसे सॉल्व होगा
sir ji pdf file pdf bhi likha huva second page pe aa raha hai.. usko kaise adjust kare
Sir i am facing some problems for doing this. I find run time error 5 when i coding
सर , मैंने आपकी विडियो देखि बहुत आछी लगी मैंने एक्सेल में काम भी किया किन्तु एक्सेल में सेव तो हो रही किन्तु फोल्डर में नहीं जा रही है न ही document में बिल नो. से सेव हो रही है कृपया मदद करे ! धन्यवाद
Sir invoice number aur customer name 2 save karna Raha to kaise kare
I am not able to create the Assign Micro on PDF Button, PDF file is not creating, showing Run Time error 5,
How to download VBA code it getting error for me
Run time - error '5' show ho rha hai
Can we make PDF uneditable ...???
how to write total SUM in words
pdf me 2 page ate hai button bhi dikh raha hai pdf me
The only problem is that even if i change the destination folder it saves the pdf in documents... how can I fix it?
Sir ek company save hone par wahi company dusi bar save nahi hoti hai invoice no. Main yah problem nahi ata haii
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
Run time error '1004':
Document not saved. The document may be oepn, or an error may have been encountered when saying
Plz resolve Sir
i cannot saved it. shows as runtime error 5
Sir mera sub yellow me highlight ho raha hai
Run time error 5.
Invalid procedure call or argument. Dekharaha hay
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