08-02-2012 05:19 PM
I am writing code that modifies an existing excel sheet however, it opens excel file every time I run the code. I just want to modify the excel sheet without opening it
08-02-2012 08:43 PM
@xochitlga wrote:
I am writing code that modifies an existing excel sheet however, it opens excel file every time I run the code. I just want to modify the excel sheet without opening it
You don't need to make Excel visible to edit a worksheet. This property can be set via ActiveX.
08-03-2012 11:28 AM
Hello,
Change the 'True' constant wired to the property node that specifies 'Visible' to 'False'.
Joel C
National Instruments
08-03-2012 11:54 AM
Thanks that worked, however now I want to continue edit the excel sheet without getting the following message:
PSU Test.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen PSU Test.xls?
08-03-2012 12:05 PM - edited 08-03-2012 12:05 PM
@xochitlga wrote:
Thanks that worked, however now I want to continue edit the excel sheet without getting the following message:
PSU Test.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen PSU Test.xls?
I cannot view your VI since you are LabVIEW 2011, but you are apparently not closing that file.
08-03-2012 12:16 PM
I have attached 2009 version does that work for you?
08-03-2012 12:18 PM
I have 8.6
08-03-2012 12:24 PM
here you go
08-03-2012 12:42 PM - edited 08-03-2012 12:44 PM
I don't see anything in your VI that closes the Excel file and shuts down Excel.
Have you looked at Help -> Examples on how to work with Excel with ActiveX?
08-03-2012 02:20 PM
I have added a close workbook and quit excel invoke node, but I am still getting messages like these:
Do you want to save changes you made to 'test_2.xlsx'?
Like I mentioned before I want to continue to edit and save the excel sheet without anny pop up message