1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

invoice generation

Discussion in 'VBA Macros' started by Amjad, Apr 21, 2017.

  1. Amjad

    Amjad Member

    Messages:
    73
    Hi all

    i need to generate bills in word format form excel

    My excel sheet contain all the details i need to create bills for each row in word format .
    files should be saved in name.doc format.

    sample files attached

    underlined datas in word document should be copied from excel rows

    regards
    amjad

    Attached Files:

  2. SirJB7

    SirJB7 Excel R┼Źnin

    Messages:
    8,486
    Thomas Kuriakose likes this.
  3. Amjad

    Amjad Member

    Messages:
    73
    Hi SirJB7
    thanks for your quick reply...my intention is to print the all bills(ie SA900.docx) that will be generated from excel macro(SA Bills.xlsm)
  4. vletm

    vletm Well-Known Member

    Messages:
    2,399
    Amjad
    1) Bold wanted SA no's from 'Bill'-sheet
    2) Press [ PrintOut ]-button in Cell[B1]
    3) Check Your printer

    Attached Files:

    Amjad likes this.
  5. Amjad

    Amjad Member

    Messages:
    73
    Hi vletm

    Thanks for your solution.

    Please modify the macro to save the result (as SAno.doc or SAno.xls format) into a folder instead of print. So that i can verify and send

    regards
    Amjad
  6. vletm

    vletm Well-Known Member

    Messages:
    2,399
    Amjad
    #3 ..my intention is to print the all bills
    #5 to save the result (as SAno.doc or SAno.xls format) into a folder instead of print.
    1) Is it windy?
    2) What is connection with SA900.docx-file?

    Attached Files:

    Thomas Kuriakose and Amjad like this.
  7. Amjad

    Amjad Member

    Messages:
    73
    Thanks for your quick solution

    working fine

    regards
    Amjad
  8. Amjad

    Amjad Member

    Messages:
    73
    Hi vletm

    output file contains formula and reference to SAbills.xlsm. How to use paste special ...so that i can able to send only output file

    regards
    Amjad

    Attached Files:

  9. vletm

    vletm Well-Known Member

    Messages:
    2,399
    Amjad
    If You would like to use 'paste special' then You would do it manually.
    I would do this another way.
    ... it's always nice to get answers

    Attached Files:

    Amjad likes this.

Share This Page