ActiveX and Excel Questions

[GaryN]

I've done searches and haven't really found what I'm looking for so maybe you guys can help.

Basically what I want to do is retrieve a named location from Excel and place it on the front panel. I figure the way to do that would be to have an ActiveX container and put the data into that. It is here where I get stuck. Is this possible? I haven't found a way to do that from browsing the VIs and properties. There's a clearer list below of the order I want to do things in.

1) Open Excel (done);
2) Retrieve an area of my excel file (done);
3) take the excel 2-D data area and put the data into a specific area (inside a box for instance) on the FP;
4) Do what ever I wanna do to the data and write (and save) it back to Excel;
5) Close Excel (done)

Is this possible? Or am I being a little too ambitious?

Gary D

[mikeporter]

Doesn't sound very ambitious at all. There are many examples shipping with LV on how to interact with Excel. In addition, I have within the past day or so seen some posts on how to read and write 2D arrays of values. I guess my question is that if you are going to be manipulating the data in LV, why mess with Excel at all?

Mike...

[GaryN]

---

@mikeporter wrote:
Doesn't sound very ambitious at all. There are many examples shipping with LV on how to interact with Excel. In addition, I have within the past day or so seen some posts on how to read and write 2D arrays of values. I guess my question is that if you are going to be manipulating the data in LV, why mess with Excel at all?

Mike...

---

The way our files are edited now through LV is a pain. Everything is stored in Excel but the data presented in a manageable, albeit very tedious, way through our interface. I'm trying to make it easier to view and easier to change multiple things at once by basically allowing the user to edit the Excel stuff from the LV environment where the data will look like more than justa bunch of numbers in rows and columns.

Thanks for the info though, I'll revise my searches and see if I can find some clues to help me towards my goal. Thanks.

Gary

[unclebump]

Have you looked at using Diadem or the new datamine stuff??

[GaryN]

---

@unclebump wrote:
Have you looked at using Diadem or the new datamine stuff??

---

No, no I haven't. More to investigate. Thanks.