4 Replies - 2189 Views - Last Post: 04 March 2013 - 10:15 PM Rate Topic: -----

#1 aswa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 13-February 13

OLE excel chart in visual basic 6 form

Posted 03 March 2013 - 08:06 AM

Hey!

I'm doing this vb 6 project, and I have a question, which is probably basic.
In one of my forms, i'm inserting an existing chart from excel using OLE.
but when I edit my excel table, the pie chart gets modified there, but not in the form.

Is there anyway I can make the pie charts in my FORM update alongside the one from excel?
I hope my question is clear..
Is This A Good Question/Topic? 0
  • +

Replies To: OLE excel chart in visual basic 6 form

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: OLE excel chart in visual basic 6 form

Posted 03 March 2013 - 09:30 PM

You're confusing linking and embedding. Read this.

Boy, now I feel old...
Was This Post Helpful? 0
  • +
  • -

#3 aswa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 13-February 13

Re: OLE excel chart in visual basic 6 form

Posted 04 March 2013 - 10:53 AM

View PostBobRodes, on 03 March 2013 - 09:30 PM, said:

You're confusing linking and embedding. Read this.

Boy, now I feel old...


I'm really sorry :( i'm new at this..
I understood the difference now.

as you can see, I need all the help I can get, and I have this project that I have to submit, and I've bit off more than i can chew, and it's too late to go back :\

so..I'd really appreciate it, if you could help me here, like atleast how to insert this linked excel chart object and how to make this reference.. :\

Thank you!
Was This Post Helpful? 0
  • +
  • -

#4 aswa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 13-February 13

Re: OLE excel chart in visual basic 6 form

Posted 04 March 2013 - 11:34 AM

View Postaswa, on 04 March 2013 - 10:53 AM, said:

View PostBobRodes, on 03 March 2013 - 09:30 PM, said:

You're confusing linking and embedding. Read this.

Boy, now I feel old...


I'm really sorry :(/> i'm new at this..
I understood the difference now.

as you can see, I need all the help I can get, and I have this project that I have to submit, and I've bit off more than i can chew, and it's too late to go back :\

so..I'd really appreciate it, if you could help me here, like atleast how to insert this linked excel chart object and how to make this reference.. :\

Thank you!



I read up a link and i followed the 6 steps mentioned:

"To insert a linked object using the Insert Object dialog box-
1)Draw an OLE container control on a form.
The Insert Object dialog box is displayed. You can also display this dialog box at any time by clicking the OLE container control with the right mouse button and then choosing the Insert Object command.
2)Select the Create from File option button.

3)Choose the Browse button.
A Browse dialog box is displayed.
4)Select the file you want to link.

5)Click Insert to return to the Insert Object dialog box.

6)Select the Link check box in the Insert Object dialog box, and choose OK to create the linked object.

I followed these steps.
"

then there's this part in the link which says:

"When you use a linked object, every user who runs your application must have access (a valid path) to the linked file and a copy of the application that created the file. Otherwise, when your application is run, an image of the original data is displayed, but the user will not be able to modify the data, nor will the user see changes others may have made to the linked data. This may be a concern if your application is running on a network.
If your application contains a linked object, it is possible for that object's data to be changed by another application when your application is not running. The next time your application is run, changes to the source file do not automatically appear in the OLE container control. To display the current data in the OLE container control, use the control's Update method:
oleObj.Update"

I used OLE1.update, but when i run it, it's not updated. it only gets updated when i right click>edit>save changes at run time.
I want the changes to be made already when i run it, without the me having to right click>edit etc :\
Was This Post Helpful? 0
  • +
  • -

#5 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: OLE excel chart in visual basic 6 form

Posted 04 March 2013 - 10:15 PM

I dunno. It's been maybe 15 years since I did one, so I'd have to tinker around with it ust like you. I also have the added burden of figuring out what you are talking about, not to mention trying to set up the same situation that you have. So, work harder, because right now you appear to be asking me to work harder on your problem than you are willing to.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1