Exporting: exporting report in MS WORD

    Hi,


    I wrote for exporting report in MS WORD. But I m not able to use template WORD file for my application.


    Following is example(This is not actual appplication):
    When application runs form shows Student name in text box "PRADEEP" and another text box showing address "INDIA" .
    In MS WORD template doc file i already put text "STUDENT NAME :" at first line and on third liane "ADDRESS:". I want to display in MS WORD template file (Which is opened through code--) student name "PRADEEP" in front of "STUDENT NAME :". (It shows ----> "STUDENT NAME RADEEP" ) and on third line (Skip second line) "INDIA" in front of "ADDRESS:"(It shows ----> "ADDRESS: :INDIA" )
    --------


    First line of document is ----->STUDENT NAME RADEEP
    Second line of document is ----->ADDRESS: INDIA


    Actually I required insert TEXT in word file at specified line or paragraph through code.
    Pls help me solving my problem. If u send some sample code (or application), it is very useful for me.
    Thanks


    Pls send reply to [email protected]


    Regards,
    Pradeep

    Hi, Pradeep.


    I don't know code real well, but I believe that people put BOOKMARKS in the Word template and then take the value of the bookmark and "populate" it with the value from Excel.


    Also, try mail merge from Word!


    I hope these help.

    Not sure if this will provide what you are looking for. But the attached creates a formatted Work document from an Excel worksheet. The macros are linked to the Text Boxes on the summary sheet.

    Interesting question on whether yuou can bid. That file was extracted from my church's auction last spring so these items are gone.


    I'm toying with posting an advance copy to the web prior to next year's (March). I wonder if they would take remote bids? It's alwyas been an on-site partially social event (plus money-maker for charities) to date. But since I see you are in PA, you might just drop down ... it's in Northern VA just outside D.C.


    Interesting the options and questions that Excel and the Web lead to.

    Re: Exporting: exporting report in MS WORD


    OK,
    so this was years ago, but i'm trying to do something similar but i can't see the attachment. I'm trying to copy images selected on a user form into a word document
    can you post it again - or even better, guide me in how i can modify the code to suit my needs?
    many thanks
    mac


    Quote from thomach

    Not sure if this will provide what you are looking for. But the attached creates a formatted Work document from an Excel worksheet. The macros are linked to the Text Boxes on the summary sheet.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login