From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
10-21-2015 12:56 PM
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?
Solved! Go to Solution.
10-21-2015 01:17 PM
@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/
10-21-2015 01:21 PM
Thanks. Not as helpful as I was hoping for.
10-21-2015 01:29 PM
@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.
10-21-2015 01:31 PM
Wow, I was just looking for some help, you don have to be such a jerk, hows your moms basement??
10-21-2015 01:33 PM
@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.
10-21-2015 01:35 PM
HAHA, dont worry, I got it thanks buddy.
10-21-2015 01:36 PM
@Oneillp111 wrote:
HAHA, dont worry, I got it thanks buddy.
That was magic, wasn't it?