Consulting

Page 4 of 4 FirstFirst ... 2 3 4
Results 61 to 69 of 69

Thread: How to set currency with different starting values

  1. #61
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,017
    Location
    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.

  2. #62
    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?!

  3. #63
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,017
    Location
    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.

  4. #64
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,017
    Location
    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.
    Attached Files Attached Files
    Semper in excretia sumus; solum profundum variat.

  5. #65
    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!

  6. #66
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,017
    Location
    Excellent! Stay safe
    Semper in excretia sumus; solum profundum variat.

  7. #67
    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?

  8. #68
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,017
    Location
    Hi. Glad it's all okay

    You would have to start a new thread, Stay Safe!
    Semper in excretia sumus; solum profundum variat.

  9. #69
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,336
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •