There are a couple issues with your code.
1. You have a broken run arrow because not all of the terminals in the Workbooks Invoke Node are wired.
2. You are not closing your references properly. You are closing the reference to an object immediately after you use it.
For instance, you are closing the reference to the application right after you use an Invoke Node with it to get the Workbooks. Once you've closed the application reference, the workbooks reference becomes meaningless. This behavior occurs all through the chain of your code.
You need to close references in the reverse order that you open them after you are completely done using them. See this thread.
http://forums.ni.com/ni/board/message?board.id=170&view=by_date_ascending&message.id=64861#M64861
Also, you have several Controls on your front panel that are used to define the ActiveX class in the Variant to Data functions on your block diagram. You can just go to the block diagram and change them to constants.
Message Edited by Ravens Fan on 03-27-2009 09:47 PM
