Excel to LabVIEW

[Mac98]

I can't run both of them at the same time. There will always be an error. And i cant seem to solve it. Does anyone knows how to solve?

[LV_user1]

Can you post your vi in lower version so that I can open it.

Also, when you are saying cannot run both at the same time do you mean you can not access two excel files at the same time?

[PalanivelThiruvenkadam]

Share your Excel Driver VI

Not able to View your LOW LEVEL VI's

I Guess you are holding the reference of the excel file in shift reg and calling different excel files without closing the session, it wont properly. try to Make the driver in such a way that it can open two work books at a time.

[Bob_Schor]

You are using "Excel" functions (SV Open Excel, SV Open XLS, SV Open Worksheet, SV Cells) that are not part of NI LabVIEW.  Are these possibly part of a third-party add-on?  If so, you need to ask the third party what is going on.  If these are routines that you wrote to do low-level Excel processing using NI's Report Generation Toolkit, then post them, as well, and we can try to figure it out.

Bob Schor

[Mac98]

I saw someone use it on Youtube and i downloaded his program. the difference is in his program it was only 1 excel file going in. but i need 2 of it so i thought why not just duplicate the program but change the excel file going in. 

https://www.youtube.com/watch?v=qIWcMPuDvBU&t=213s

[RTSLVU]

I am guessing that the sub-vi's that were not included use the LV Excel Report Generation Toolkit.

The toolkit uses ActiveX to automate Excel and only on instance of ActiveX can control Excel at a time.

You need to make your program more sequential in the way it access Excel.

[Mac98]

Here are the sub VI's and i dont understand what u mean

[PalanivelThiruvenkadam]

Use SV Open XL once and use the Output to Open different workbook (SV Open XLS) and close the workbook and related reference once read.

[Mac98]

---

@PalanivelThiruvenkadam wrote:

Use SV Open XL once and use the Output to Open different workbook (SV Open XLS) and close the workbook and related reference once read.

---

problem is i need to open two excel at the same time. but the block diagram i showed above can only open one at a time

[PalanivelThiruvenkadam]

Excel is an application (One instance will support multiple workbooks), Your two files are two workbooks can be opened together in one excel application.