How to control NI USB-6509 with Micrsoft Excel Macro?

[Boosa]

Hello,

I recently brought NI USB-6509 (96 channel USB to Digital IO) and tested ok with Labview. But i wanted to detect and control the same device in microsoft excel. Can anyone suggest me some solutions to work on excel with this device?

[Dennis_Knutson · Accepted solution]

Look here and here. For other examples, do a search for 'DAQmx VBA'.

[Boosa]

Hello Dennis,

That was very useful for me to start with the instrument.

I have a problem where the device is resetting after every read.

My application is to read the entire port and modify one bit in the port. Here is how i am doing the activity

Step 1 : Create Task handle for both write and read activities

Step 2 : Read the port and store in buffer

Step 3 : Modify read buffer

Step 4 : Send the modified data to same port (bit modification)

This works fine first time. When i repeat the same from Step 2, all ports are getting reset to defualt values instead of previous data.

I am absolutely blank why device is resetting when i am reading.

I will be thankful to you if you could help me in this.

I am also attaching VB code for your reference.