Read about excel - word integration?

[Gunnar Johansson]

Hi,


Any suggestions about where to read about creating word reports from excel
vba and excel's charts & data?

Web links and book review are both welcome.

/Regards

 

[Jon Peltier]

Gunnar -

I have some information about cross-application automation here:

http://peltiertech.com/Excel/XL_PPT.html

Mostly it's Excel and PowerPoint, but the concepts are the same. Also, MS has a
large number of pages on their site, which unfortunately are easier to find by
accident. Here are a few:

OFF97: Microsoft Office 97 Automation Help File Available
http://support.microsoft.com/kb/q167223/

How To Create a Report in Word w/Excel Chart via OLE Automation
http://support.microsoft.com/default.aspx?scid=kb;en-us;114378

Communicating with Other Applications
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/html/wohowcommunication.asp

Give Excel the Power of Word Spelling and Grammar Checking
http://www.microsoft.com/exceldev/articles/chkExcel.htm

Creating Integrated Office Solutions for Microsoft Office
http://www.microsoft.com/OfficeDev/Articles/IntegOff.htm

Using Word as a Report Generation Component
http://www.microsoft.com/worddev/articles/movs108.htm

Cross-Application Automation Samples
http://www.microsoft.com/officedev/articles/sampauto.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno97ta/html/sampauto.asp
http://www.microsoft.com/downloads/...88-9695-45f3-a564-18cff2bf61f5&displaylang=en

Automating Microsoft Office 97 and Microsoft Office 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2kta/html/offaut.asp

Microsoft Word Visual Basic Reference
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/womscwhatsnewdev.asp


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______