help needed to show Excel graphs (only) in VB window

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Aug 2006
Posts: 1
Reputation: sen06 is an unknown quantity at this point 
Solved Threads: 0
sen06 sen06 is offline Offline
Newbie Poster

help needed to show Excel graphs (only) in VB window

 
0
  #1
Aug 16th, 2006
hi to everyone,
here is a minor problem I am facing. Any help/suggestions is dearly welcome.
I have an Excell file full of data and calculations. There are a few graphs as well. Now i want to open those Ghraphs (only) on certain VB windows.
I tried both the OLE option and the Picturebox option. In both ways the Graphs are displayed in VB windows alright. But in OLE, the problem is that there comes a Right-Click option that allows users to Edit the graph from the VB window itself. I don't exactly want this. These graphs are just for user-reference. The input/edit/update/delete in the actual Excel file is the adminstrator's job, or else should be manipulated through another VB window inviting users to input / edit specific data. I am not sure if it is possible the way I am trying it!
In picture box, it looks better, but the 'picture-graph' cant access the original file, hence any change in it is not shown on the graph. Is there any possible solution to this?
I am quite new in programming. Will love to hear from you, friends.
cheers
Sen
Last edited by sen06; Aug 16th, 2006 at 12:58 pm.
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 2,413
Reputation: Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough 
Solved Threads: 211
Team Colleague
Comatose's Avatar
Comatose Comatose is offline Offline
Taboo Programmer

Re: help needed to show Excel graphs (only) in VB window

 
0
  #2
Aug 16th, 2006
Hmn, I don't understand the problem with the picturebox.... you can make it load pictures from files and what not, right? Maybe we can make excel export the graph (and only the graph) to a file?
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC