Open up a blank word document when I open Excel

[barneyrubble1965]

Is it possible to open a blank MS Word document whenever I open a specific Excel file ?

[TMS]

Use the Workbook_Open macro to call the following NewWordDocument subroutine:

Please Login or Register  to view this content.

(in a standard module)

Please Login or Register  to view this content.

[xlnitwit]

Or you might reduce that to

Please Login or Register  to view this content.

[TMS]

@xlnitwit: very concise and effective. Shows how often I open a Word Document from Excel.

How would you go about assigning that document to a variable so that you could refer to it later in your code?

[xlnitwit]

I'd use

Please Login or Register  to view this content.

Thanks for the rep, by the way!

[TMS]

Thanks for the rep, by the way!

My pleasure