vipersmind
it can't be!
- Local time
- Today, 08:15
- Joined
- Dec 26, 2002
- Messages
- 82
Hi
I have embeded Excel 2003 sheets embeded into my form (better charts) and I have two sheets on the excel -
sheet1 - chart (chart is only displayed on the form)
sheet2 - external data query pulled from within the same database
My issue is that I can refresh the data (Sheet2) only when I go into design view of the form.
Is there a way to refresh the data on sheet2 using vb or have I gone about this the worng way?
I have dynamic query that the user can run to select different data for the chart. The query writes to a table and this is linked to sheet2. I would like the chart to refresh after update but I can't work it out.
I have searched my places for the resolution.
***I am going to try using vb to setup/control MS Graph if anyone has an example to start me off in the right direction it would be greatly appreciated.
Cheers
Cress
I have embeded Excel 2003 sheets embeded into my form (better charts) and I have two sheets on the excel -
sheet1 - chart (chart is only displayed on the form)
sheet2 - external data query pulled from within the same database
My issue is that I can refresh the data (Sheet2) only when I go into design view of the form.
Is there a way to refresh the data on sheet2 using vb or have I gone about this the worng way?
I have dynamic query that the user can run to select different data for the chart. The query writes to a table and this is linked to sheet2. I would like the chart to refresh after update but I can't work it out.
I have searched my places for the resolution.
***I am going to try using vb to setup/control MS Graph if anyone has an example to start me off in the right direction it would be greatly appreciated.
Cheers
Cress
Last edited:
