How to open and display Excel with Active X (LV7.1) ?

[davey31415]

Hi,

I am trying to debug an old LV7.1 code which uses ActiveX to interface with Excel.  It worked fine before but with a new LV/Office installation something seems to have change.

The program is using the Automation Open function to open an Excel._Application object, adds a sheet through an invoke method and then continues working with Excel.  In the task manager I can see that an instance of Excel opens.  How can I make the workbook visible?

For some reason the Excel workbook is not saving and I'm hoping I will have an easier time debugging what is going on if I can see if the workbook is being populated properly.

Thanks,

Dave

[davey31415]

Regardless of how much time I spend trying to find the answer to a question it seems the most likely time I will stumble onto it on my own is seconds after posting a question.  I hope it helps someone else one day:

Create a property node and set the DisplayFullScreen propety to True.  This does not show the normal view of Excel but it is better than nothing.  If anyone knows how to display the normal view please let me know.

Dave

[RavensFan]

If you post the VI as you have it now, then it will be easier for others to figure out what needs to be fixed.

Also browse through the Excel thread for more Excel related questions and answers.p>

Message Edited by Ravens Fan on 11-12-2009 09:38 PM

[smercurio_fc]

---

davey31415 wrote:

Regardless of how much time I spend trying to find the answer to a question it seems the most likely time I will stumble onto it on my own is seconds after posting a question.  I hope it helps someone else one day:

Create a property node and set the DisplayFullScreen propety to True.  This does not show the normal view of Excel but it is better than nothing.  If anyone knows how to display the normal view please let me know.

Dave

---

I'm not sure what you mean by the "normal view". However, the Excel Application object has a "Visible" property. Have you tried that? That's what's normally used to display Excel's window when opening it via automation.

[srikrishnaNF]

Hi davey31415,

  Actually you did almost 90% of the program to open the excel file.Actually when you open the automation connection Excel._application,you must  put a propertynode and select one property by name visible and set it true and select workbooks property and continue....This will definitely,open your excel and display.

Thanks and regards,

srikrishnaNF