LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Working VI to not close all instances of Excel

Solved!
Go to solution

I have a VI that I found on the NI website.  It searched an excel file, in a specific cell location, etc "A1" and returns what ever is in that cell location.  Then it closes the file and Excel, including all other workbooks.  Can anyone help me change this so that it will only close the workbook that has been opened by the VI?

0 Kudos
Message 1 of 8
(3,627 Views)

@Oneillp111 wrote:

I have a VI that I found on the NI website.  It searched an excel file, in a specific cell location, etc "A1" and returns what ever is in that cell location.  Then it closes the file and Excel, including all other workbooks.  Can anyone help me change this so that it will only close the workbook that has been opened by the VI?


Start learning the Excel Object Model. http://analysistabs.com/excel-vba/open-close-existing-workbook/

0 Kudos
Message 2 of 8
(3,616 Views)

Thanks. Not as helpful as I was hoping for.

0 Kudos
Message 3 of 8
(3,607 Views)

@Oneillp111 wrote:

Thanks. Not as helpful as I was hoping for.


Maybe someone will do your work for you, but I prefer to learn how to do the work myself.

 

As for "not helpful", if you are going to use actual Excel and don't want to use the Report Generation Toolkit, then you had better get yourself familiar with the Excel Object Model.

0 Kudos
Message 4 of 8
(3,602 Views)

Wow, I was just looking for some help, you don have to be such a jerk, hows your moms basement??

0 Kudos
Message 5 of 8
(3,596 Views)

@Oneillp111 wrote:

Wow, I was just looking for some help, you don have to be such a jerk, hows your moms basement??


No, not help.

 

You were looking for someone to do work for you.

 

If you were looking for help, you'd post a VI of what you have attempted.

 

0 Kudos
Message 6 of 8
(3,590 Views)
Solution
Accepted by topic author Oneillp111

HAHA, dont worry, I got it thanks buddy.

0 Kudos
Message 7 of 8
(3,582 Views)

@Oneillp111 wrote:

HAHA, dont worry, I got it thanks buddy.


That was magic, wasn't it?

0 Kudos
Message 8 of 8
(3,576 Views)