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.

Thanks

Re: Passing Variables From Workbook To A Word Macro

Ah, that worked perfectly! I should've realized that earlier. I'm such a fool.

Thanks a lot Daniel!

Re: Passing Variables From Workbook To A Word Macro

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

Dim var1 As String
Dim var2 As String
Dim var3 As String


    Selection.MoveUp Unit:=wdLine, Count:=3
    Selection.TypeText Text:=var1
    Selection.MoveDown Unit:=wdLine, Count:=1
    Selection.TypeText Text:=var2
    Selection.MoveDown Unit:=wdLine, Count:=1
    Selection.TypeText Text:=var3


    Application.PrintOut...

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)

EXCEL MACRO SECTION -

...
    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?