Did you run an earlier version by mistake?
Have you put the new BlankQuote in the directory C:\Users\Administrator\Desktop\W\Reports\?
Are you opening the correct BlankQuote? It will have the timestamp on it similar to my attachment above.
Did you run an earlier version by mistake?
Have you put the new BlankQuote in the directory C:\Users\Administrator\Desktop\W\Reports\?
Are you opening the correct BlankQuote? It will have the timestamp on it similar to my attachment above.
Last edited by paulked; 05-02-2020 at 10:53 AM. Reason: Added 1st and obvious question!
Semper in excretia sumus; solum profundum variat.
Ok it was me, I had the BlankQuote.xlsx in the incorrect location. I fixed that.
Then I had to not delete row1 so that item # 1221 would work.
Then I re added the line to hide sheet 2.
I'll have the team go over and make sure it works for them as intended.
This is great! You have been a substantial help!
Other than adding rep to you how else can I repay the time and effort?!
No need for repayment, I'm a VBA intern and learning is payment enough! It is nice to help people, especially in these unprecidented times.
Take care and stay safe
PS Thanks for the Rep!
Semper in excretia sumus; solum profundum variat.
BTW, while I was testing I used a count-down routine that enables you to interupt the macro within 10 secs of opening the file. If you don't press a button within the 10 secs the macro runs as normal. You may find it handy for testing yourself, so I've attached it.
Semper in excretia sumus; solum profundum variat.
Just wanted to give an update! Everything is working beautifully, all 3 sheets have been successfully implemented into routine!
Again thank you very much, I am now excited to start looking for other VBA projects to optimize time!
Excellent! Stay safe
Semper in excretia sumus; solum profundum variat.
Hello again!
So far everyone is very happy and all of the Pricebooks/Quote Forms are working beautifully!
So again, thank you!
So I have a new VBA Project, should I continue here, or make a new thread?
Hi. Glad it's all okay
You would have to start a new thread, Stay Safe!
Semper in excretia sumus; solum profundum variat.
And mark this one [SOLVED] using Thread Tools above your first post
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3