Posts by watsonps2

    Re: Display Rows Of Interest Only

    Hmm, that makes sense...
    Ill probably add a column at the end for the same. (I cant change the existing structure since there quite a few mail merges based on it)

    Thanks for that, although i'm still curious, is there any way to pick up a range of cells and have it "pop-up"?

    Hey all,

    I have this sheet at work which contains a bunch of courses my employer runs, alongwith the dates and other details (which spans columns A through O)

    Course-rows which require action/follow-up are highlighted with a certain color. The "completed" course-rows have no fill.
    Note: the courses requiring action may have a past date, the only distinguishing feature is the highlight color.

    Is there any way by which i could generate a pop-up box of some sort which would display the "highlighted" rows (maybe from A through I or something).
    I could add 'follow-up' flags on another column if the highlight color won't do.


    Re: Passing Variables From Workbook To A Word Macro

    Pretty simple code (i'm not sure if i'm missing something here)

    Re: Passing Variables From Workbook To A Word Macro

    I've dim'ed the three variables as strings in the macro, and they take their values from different cells in the workbook.

    I assume the Microsoft Word 11.0 reference is adequate?

    Is there any other way of passing the variables?

    Hey all,

    I've got a macro in an excel sheet, which when invoked should -
    - pick up data from the sheet and create an email based on specific cell values
    - open a specific word document and run a macro in the word document that would add a few user-specified number of rows in a table and then print it out

    What i would also like to do is, before printing, paste variables passed from excel in the document

    Everything works perfectly except for the passing variables from the excel macro to the word macro part. I cant seem to figure out the syntax to do that. I always send up with Error 450 "Wrong number of arguments or invalid property assignment "
    (the word document prints, as long as i dont pass the variables)


        Set appWD = CreateObject("Word.Application")
        appWD.Visible = True
        appWD.Documents.Open Filename:="C:\Attendence Record.doc"
        appWD.Run "PrintTable", "var1", "var2", "var3"

    So, how do I pass these variables to the PrintTable macro in word?