|
-
Mar 22nd, 2012, 09:19 PM
#1
Thread Starter
New Member
Display excel chart in VB6.0 Form with OLE
Hi everyone!
Last year i made a program which opened an excel file and changed some cells values. Previously in the excel book i had created a chart from data that depends on these cells im changing, so the chart changes every time the program is runned.
Now, i dont know how, i managed via an OLE, to insert the chart and to display in the OLE this chart. Excel was never shown for the user, the chart was directly actualized and displayed in the VB Form.
The program still runs correctly in the PC where i deveolped the program Windows XP and Excel 2003. At present im using Windows vista 64 bits and Office 2010. And everything works fine, the excel book is modified as it should and the chart changes automatically. The thing is i cant get to display the new chart, it displays always the same chart, an old chart, it is not getting actualised even though when i open the excel book i can see the new chart.
Can someone help me with this?
Thanks a lot
PD: sorry for my poor english i hope you understand!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|