+ Reply to Thread
Results 1 to 4 of 4

Auto Invoice Generator

  1. #1
    Registered User
    Join Date
    03-17-2021
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    2

    Auto Invoice Generator

    Hi everyone,

    I am hoping to do this for my company and I have incredibly limited knowledge about this, so thank you in advance!

    We are trying to have an Invoice Generator which only generates an Invoice number after we save it as a PDF.

    Also hoping the PDF name generated is based on information filled in prior to saving, for example: YYMMDD### Type Customer.pdf

    So not only will the Macro generate the name of the PDF based on information on the excel but also filling in the Invoice number back into the excel itself ie: YYMMDD###

    Reason for the number to only be generated after saving as PDF and not upon opening is because we don't want a colleague to accidentally open or a customer cancelling mid-way and having an Invoice number generated but never saved making audit wonder what happened to that particular invoice went.

    Again appreciate all the help! Thank you!

    Dixon

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,232

    Re: Auto Invoice Generator

    .
    Generating the next Invoice Number can be as simple as :

    Please Login or Register  to view this content.

    You can include the above code in your SAVE routine prior to actually saving the document or it can be attached to a COMMAND BUTTON
    and the next number generated by clicking the button.

    See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-17-2021
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    2

    Re: Auto Invoice Generator

    Hi, thanks for the reply

    But I am really looking for a more specific Invoice Generator whereby a Macro that will generate the name of the PDF based on information on the excel and not merely 001, 002 etc.

    Thank you very much!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,232

    Re: Auto Invoice Generator

    .
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic invoice generator need help with code
    By stokke5 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2019, 01:47 AM
  2. [SOLVED] Help creating automatic invoice number generator
    By hunting4bison in forum Excel General
    Replies: 6
    Last Post: 06-30-2016, 12:02 PM
  3. Help with automated invoice generator
    By Michael2992 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2016, 05:27 PM
  4. Need help with the macros on a invoice generator.
    By heinstransport in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-02-2015, 10:54 AM
  5. [SOLVED] Macros Print multiple invoice Generator 2 different customers per single page Odd/Even num
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-25-2013, 11:20 PM
  6. Anyone need a timesheet invoice generator for contract work?
    By DaveDeV in forum Tips and Tutorials
    Replies: 1
    Last Post: 05-17-2013, 07:01 PM
  7. Self saving Excel 2007 template with Invoice number generator
    By Tomacat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2011, 02:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1