Append multiple exports to one doc

[Brian Lukanic]

I'm making customized views/filters/tables to display exactly the task
information that I want to export into a Word status report. What I want to
do is write a macro that calls these different views and then invokes the
"Copy Picture to Office Wizard" to send it to Word. So far it's working
great, but I want to be able to have a single macro that does multiple
exports onto the same Word Doc.

Is there VB syntax I can use that would allow the macro to start "Export #2"
and send the picture to "current Word Doc?" This is pseudocode of course, but
essentially I want to end up with one macro that creates multiple exports
onto a single Word file. The fewer keystrokes to the end user the better.

 

[Rod Gill]

From Project, using Automation, you can control everything in Word and vice
versa.

Search msdn.microsoft.com for sample code and
http://word.mvps.org/FAQs/MacrosVBA/index.htm is also very good.

Alternatively, my book has plenty of working code between Project and Excel
(including using timephased data). Excel is better for reporting because
controlling it is easier and quicker than using Word and Excel allows chart
creation thru VBA where Word doesn't. Excel has more powerful tools for
formatting and transferring blocks of data.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Brian Lukanic]

Thanks. I actually have your book, so I will start there.

 

[Rod Gill]

Great!! Use the export to Excel macros and build your report a bit at a
time.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com