Hi guys, I know there have been previous posts with code to have an invoice save and automatically open a new one with the next number. I have been having problems getting it to work.
Here's the run-time error I get "1004"
Run-time error.jpg
And here's my code:
Please Login or Register to view this content.
I just want to be able to save an invoice, and as I save it it automatically saves the invoice number and opens the next invoice number clear and ready to fill in.
Thanks!
Last edited by brazilianch; 03-31-2014 at 03:30 PM. Reason: Code
Please take a moment to read the forum rules especially pertaining to rule #3.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
... and appear like this when posted:
Please Login or Register to view this content.
What ranges need cleared?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
It's an option to store the sequence outside the workbook.
In the example, the text file is preloaded with the value 1 and each time the code runs, the value is retrieved and the number incremented by one for next time.Please Login or Register to view this content.
Martin
Sorry about the unorganized code; it should be fixed now.
I need B9:E9 and F5 Cleared, that's just the item, description, quantity, unit price.
(I just recognized and fixed the "B9:F9" and changed it to "B9:E9")
@mrice Will this change the number each time I open the file? So if I open one and don't need it, or don't save it, I lose a number in my invoices?
You could incorporate the code into a larger routine including your save if it is important to you not to have any gaps in the sequence
E.g.
Please Login or Register to view this content.
Try pasting this to you workbook module:Please Login or Register to view this content.
@SolusRankin That code works great! I saves the file as whatever the invoice number is and clears the data. The only thing left though is auto-numbering so when I either open or save it the next numerical number auto populates. How would I do this?
That code will automatically increment F6 when you save.This will increment when you open. Change "YourSheetName" to the name of the sheet that you want to increment.Please Login or Register to view this content.
Okay so when I hit the save button I assigned the macro to, It appears to open a new workbook and close one, the information doesn't clear, and the number doesn't change? It is saving the page as the invoice number though.
Here's the entire code I've copied:
Please Login or Register to view this content.
You don't have to assign those macros to anything. Just hit the save button or go to file--> save.
When I do this, all that happens is the original file is saved. Attached is the workbook if you would like to see.
The code needs to be placed in the workbook module, not a stand alone module. Please see attached: Solus Edit.xlsm
Please note. There were a couple other issues I found that never would have been caught without an example workbook. Posting your workbook is always the best way to get a complete answer.
Awesome thanks a lot! It works great!
Glad to help. And welcome to the forum.
If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.
And on any thread you can show appreciation to those who have helped you by clicking the * below their post.
Okay thanks again, one quick final question, how do I go about changing the original file and saving it?
I placed a macro in the last example called SaveForDeveloper. Run it and it will ask you want you want to call it and where you want to save it. It will then save it for you without running the other macro.
If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks