Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    auto invoice #ing

    hi all,

    would like to know if anyone can shed some insight on my situation. I have a invoice spreasheet where I would like the invoice # to get automatically updated when the user prints an invoice (VBA or/and an external txt file). I would like to update it only when a print is requested.

    thanks,
    eddie

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: auto invoice #ing

    Hi Eddie,
    Personally, I'd add some code to the Workbook_BeforePrint event to increment the invoice# by 1. No real need for an external text file - just add 1 to the current value.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto invoice #ing

    I've got a Purchase Order spreadsheet that could probably be adapted to your needs.
    There are separate buttons for getting 'the next number' and 'print' but these could easily be combined.
    It also has an auto-lookup of names, addresses, tel and fax numbers if you need that, plus adds users email address.
    Finally, if you have fax software, it will fax it for you.

    It will need some modifying to suit your needs - wanna look-see?
    (Excel 2K)

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto invoice #ing

    sure..looks like more than what I'm looking but if I can taylor it to my needs...great.

    regards,
    eddie

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto invoice #ing

    OK - let me spend a little time removing 'sensitive' and irrelevant bits, and adding a few comments.

Posting Permissions

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