Skip to Content
0
Former Member
Oct 31, 2013 at 09:53 AM

OLE Excel chart

110 Views

Hello

I have an ole Control of Microsoft Excel Worksheet. I populate data in a sheet and show the chart based on data in Another sheet. It works fine mostly but have one problem. If I have an excel file open while running the application, program writes the data in the already open excel file instead of sheet in OLE control. Therefore chart does not show any result.

Any suggestion is appreciated.

Thanks

Vinay

Code sample:

================

OleObject lole_workbook, lole_worksheet

lole_workbook = ole_pareto.Object.application.workbooks(1)

lole_worksheet = lole_workbook.worksheets(1)

lole_worksheet.cells(1,1).value = "Dummy"