Create an Automated Invoice using Excel VBA (1-Click Save to PDF & New Invoice)

[@molusco1059]

Great video, thanks. This is the first macro of many that I tried and did not returned an error to debug. One quick question, what can I do to save the sheet as an xlsx file? Just an individual sheet. Thanks.

[@AllAbout_Excel]

Appreciate it 🙌 Try this code to save the active worksheet as a separate file. As shown in the video, change the cell reference of invoice number, customer name, and Path & Name of the New file as per your requirement. drive.google.com/file/d/1BpCW1rty7qsXn-G4jNOFosmRA703LmlZ/view?usp=sharing

[@molusco1059]

@@AllAbout_Excel Awesome. I just tried it and worked like a charm. Thanks a bunch.

[@AllAbout_Excel]

Happy to help!!

[@Bharatiya_Brothers]

sir please make vedio on ,how to search and update old saved bill please sir, THANK YOU SIR FOR THIS VEDIO

[@elijahdatu6778]

i have tried your code but i got an error message: Variable not defined - it pointed to InvoiceNo, how can i resolved this?

[@knotdavewalker]

Thank you, very clear instructions THAT work

[@mohamed.shaltout]

Thanks for the video. Can the code for a new invoice start a new blade instead of clearing the current invoice?

[@DM.10]

I have a question. It's about creating a new invoice. How is the file saved? In .pdf or .xlsx format? Thank you in advance for your answer.

[@mariireyes7352]

Hi to all, I am trying to locate properties on Mac, but Mac uses iCloud Drive, how can I add that to the VBA? Thanks in advance! ❤

[@vaghanisatish9693]

How to set invoice combination of financial year and series like 1(2023-24) 2(2023-24). End of financial year 1(2024-25)

[@abhishekawari919]

Great video !! But i have similar kind of problem where im getting 2 excel files - 1 contain dashboard file with invoice no and Amount and another file contains the invoice amount breakup by resource we have to get the info from these 2 sheets and mentioned in our template sheet( invoice format sheet) and create pdf … can we create some automation for this task ? And how

[@AllAbout_Excel]

Hi Abhishek please contact at [e-mail] I will help you out with the query

[@gamingmasterrishi]

Very good information

[@Kospisk]

Amazing job! Thanks for sharing!

[@Md.Ismail-v1e]

Thank you Sir, very nice

[@sabbirgourob]

Hi sir, after some days this code not working, showing the text on after clicking the vba button " could not create pdf". please solve me

[@Md.Ismail-v1e]

Many many thanks

[@karangupta-mb3jp]

Sir , invoice no ke jgh mujhe date ke sath save krna haii . As like 16/06/2024 Karan kumar

[@adrixrodriguez9864]

how can i print this to actual invoice with only the details only without the guidelines and words

[@kebincui]

fabulous👍👍

[@elizbethramos1721]

Love the client list

[@maureennavarette9768]

Mine has error of type mismatch. I followed everything in the video. This error is for the new invoice. My Invoice number did not change but it clear all the contents that I have listed in the range. How to fix?

[@AllAbout_Excel]

Can you share the code here. There must be some mistake

[@ayan-o-ayser]

it really worked

[@deguitarcare2596]

Is the VBA Code applicable to Google Sheet?

[@Imra_n]

Thanks ❤

[@ajadityahitesh]

Getting error Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving.

[@AllAbout_Excel]

Can you show me the code you're using

[@josephkelly4310]

will this work if im saving to my onedrive?

[@devidaspanchal6604]

IF STATEMENT ON PRICE SHOWS #VALUE ERROR ON TOTAL PLZ HELP

[@dhruvinpanchal5432]

Sir please share this Excel sheet

[@rizal9803]

how to save in excel instead?

[@itspremsagar1707]

Hello it's but when i close documents and again open the file then after it's now working. Please help me to fix this problem.

[@haniatextile]

save the excel file as micro enabled format

[@royplumber]

I have a Exel yearly income workbook and use invoice pad I leave one copy with customer then write the details into the work book when I get home is there a code for me to make a invoice on my phone and enter details print of or email a copy to my customers. Then details automatically update to my work book at home on my Mac for tax purposes kind regards

[@AllAbout_Excel]

I'm planning on making a video on this soon

[@royplumber]

@@AllAbout_Excel oh cool have you got a email address to show you what i am trying to so cheers

[@AllAbout_Excel]

[e-mail]

[@ujjwalkotnala]

Hi sir Ujjwal this side We are having different customer and they want invoice according to them , I mean we have to create invoice in multiple templates is there any way to to create such type of excel sheet so that we can create invoice in different different templates. Please make a video on this also

[@AllAbout_Excel]

Hi Ujjwal.. I'll definitely look into it

[@ujjwalkotnala]

@@AllAbout_Excel thanks it will be very helpful

[@BassamThebian]

Hi, what about if you need to edit the invoice???

[@AllAbout_Excel]

Excel VBA : Managing Invoices - Save as PDF, Open, Edit, and Overwrite Invoice Data Dynamically kzbin.info/www/bejne/aIi6pmlrl6yAitk

[@noushadalimangi4452]

i made button but when i save as pdf excel give me error 400 plz what i can do for it help me dear

[@AllAbout_Excel]

There must be some mistake in your code. Please share the code which you are using for "save as pdf"

[@noushadalimangi4452]

@@AllAbout_Excel thanks dear my issue is resolved Actually my harddrive C space is Full when i was clean same space and error is end and my file is ready Thanks again give me Email i send you my file

[@MohAboAbdo]

Thank you so much, Sir.

[@AllAbout_Excel]

Appreciate it Sir!

[@chandangowdak813]

Hi sir, I got an error while executing the save as pdf macro. Error message : Compile error: Can't assign to read-only property Please help me resolving this issue, thanks in advance

[@AllAbout_Excel]

Can you share the code which you used? Maybe, you did some error

[@chandangowdak813]

@@AllAbout_Excel Thanks for the quick response, please find the code and help me out. Sub SaveAsPDF() InvoiceNo = Range("I3") customername = Range("B3") Path = "C:\Users\admin\Documents\SMT_Invoices\" Fname = InvoiceNo & " - " & customername ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, ignoreprintareas:=False, Filename:=Path & Fname End Sub

[@AllAbout_Excel]

Your code is alright. In the left Project explorer bar in the VBA window, you are maybe selecting "this workbook" and entering code there. Try one of the following to correct it. 1. Instead of "this workbook", select the sheet which you want to convert to pdf and then enter code there. 2. Insert a New Module from the top menu bar in VBA window. Insert > Module. Then enter your code there.

[@chandangowdak813]

@@AllAbout_Excel Thanks a lot, it worked. Followed as per 1 st suggestion and it executed without any error and pdf invoice created. Thanks a lot again... Big thumbs up for the great support and educating all!😀

[@AllAbout_Excel]

Much appreciated 🙌🏻

[@kimkhanhnguyen1885]

I have an error 1004. Please help me

[@muhammedaslam5937]

Hi sir, showing error 400 after adding the createnewinvoice code

[@AllAbout_Excel]

Hi.. there must be some error in ur code.. please rewatch the video carefully and then enter it

[@SoulKingCR]

Getting this error: System Error &H8007007B (-2147024773). The filanme, directory name, or volume label syntax is incorrect.

[@bvishnupriya1836]

Getting error: 400 Save as pdf

[@dylanlittle40]

Martinez Amy Jackson Daniel Taylor Matthew

[@jaswantjain314]

How to se previous invoice

[@AllAbout_Excel]

If you have saved it as PDF, then you can check it out from the specified folder