Customized Word output from Excel VBA

[corquando]

Salvete, amici.

The Excel part of the process I'm dealing with is nailed down.

What I'm looking at is a series of transaction data that need to be displayed in Word (prior to being PDF'ed) in either landscape or portrait orientation with various numbers of rows depending on richness of data reported.

I'm thinking of doing something like a customized Avery label display but that seems kind of weak . . . is there a display/template/report structure that's available? Am I making any sense?

Thanks.

 

[Macropod]

Have you considered using mailmerge or a DATABASE field in Word? Without knowing more about what you want to produce, it's hard to give specific advice.