, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

Printing to Excel (OpenInsight 32-Bit)

At 23 MAR 2006 05:45:56AM William Ng wrote:

Hello Bob(Bob Carten),

Upgraded to 7.2.1 and tried out writing data to Excel using OLE.It works great.Very cool feature.Thanks Bob.

Can u guide me to more info or any websites about the excell application, workbook, worksheet and chart object properties, methods and etc.MSDN dont seems to be complete.Cannot find chartobject and the other methods seems not listed completely.Hope u can help me to learn more.

At 23 MAR 2006 10:43AM dsig _at_ sigafoos.org wrote:

for chart object google came back with ..

Results 1 - 10 of about 23,800,000 for chart object. (0.35 seconds)

google is your friend

At 23 MAR 2006 10:45AM dsig _at_ sigafoos.org wrote:

sorry .. too fast on that btn_submit

the top one showing on google from my search is

Making The Most Of The OLE Chart Object

The Microsoft OLE Chart Object. The other charting object for VB. Lesson 1.

www.vb123.com/toolshed/99_graphs/msolechart.htm - 32k - Cached - Similar pages

looks like it might be of some help

At 23 MAR 2006 09:16PM William Ng wrote:

Thanks for the pointers. Google is my best friend. :)

I was hoping to get a more official and complete documentation of all the available properties and methods for excell.application, workbook, worksheet, range, chart object and whatelse that i do not know yet.MSDN dont seems to have it or i have not found the right place.

Besides chart object, i also hope to find out how to set the length, font, font size as well as background colors for each cell.Can this be done?

View this thread on the Works forum...