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!!
@knotdavewalker
Жыл бұрын
Thank you, very clear instructions THAT work
@Kospisk
Жыл бұрын
Amazing job! Thanks for sharing!
@user-rm4cg2zn6x
7 ай бұрын
Thank you Sir, very nice
@gamingmasterrishi67
Жыл бұрын
Very good information
@user-rm4cg2zn6x
7 ай бұрын
Many many thanks
@kebincui
Жыл бұрын
fabulous👍👍
@ayan-o-ayser
Жыл бұрын
it really worked
@Imra_n
9 ай бұрын
Thanks ❤
@elizbethramos1721
Жыл бұрын
Love the client list
@Bharatiya_Brothers
11 ай бұрын
sir please make vedio on ,how to search and update old saved bill please sir, THANK YOU SIR FOR THIS VEDIO
@mohamed.shaltout
4 ай бұрын
Thanks for the video. Can the code for a new invoice start a new blade instead of clearing the current invoice?
@MohAboAbdo
Жыл бұрын
Thank you so much, Sir.
@AllAbout_Excel
Жыл бұрын
Appreciate it Sir!
@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
3 ай бұрын
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! ❤
@elijahdatu6778
9 ай бұрын
i have tried your code but i got an error message: Variable not defined - it pointed to InvoiceNo, how can i resolved this?
@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)
@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
@josephkelly4310
10 ай бұрын
will this work if im saving to my onedrive?
@dhruvinpanchal5432
7 күн бұрын
Sir please share this Excel sheet
@karangupta-mb3jp
Ай бұрын
Sir , invoice no ke jgh mujhe date ke sath save krna haii . As like 16/06/2024 Karan kumar
@deguitarcare2596
Жыл бұрын
Is the VBA Code applicable to Google Sheet?
@adrixrodriguez9864
Жыл бұрын
how can i print this to actual invoice with only the details only without the guidelines and words
@ajadityahitesh
2 ай бұрын
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
2 ай бұрын
Can you show me the code you're using
@rizal9803
Жыл бұрын
how to save in excel instead?
@devidaspanchal6604
10 ай бұрын
IF STATEMENT ON PRICE SHOWS #VALUE ERROR ON TOTAL PLZ HELP
@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
Жыл бұрын
Muhammadtaha940258@gmail.com
@BassamThebian
5 ай бұрын
Hi, what about if you need to edit the invoice???
@AllAbout_Excel
2 ай бұрын
Excel VBA : Managing Invoices - Save as PDF, Open, Edit, and Overwrite Invoice Data Dynamically kzitem.info/news/bejne/k42N22prm3l-h6w
@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
@kimkhanhnguyen1885
5 ай бұрын
I have an error 1004. Please help me
@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
@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
@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
@bvishnupriya1836
5 ай бұрын
Getting error: 400 Save as pdf
@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
@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 🙌🏻
@kevinmoralesk9
Жыл бұрын
Getting this error: System Error &H8007007B (-2147024773). The filanme, directory name, or volume label syntax is incorrect.
Пікірлер: 58