How to import data to excel sheet from logic analyzer

[rabishankar]

I am working with Agilent Logic Analyzer16700.Here the out put from the Logic analyzer is to be imported to excel sheet.I went through help for the device and saw that it needs a toolbar addin in excel which directly imports the data to excell sheet.But that is to be done manually.I wanted to know that,whether it is possible to import the data automatically using labview.Earlier i googled through net and found that Mr Helge and Mr Blad has done some work with this device.Looking forward to their help and help from other guys too.

Thanks in Advance.

[Hillary_C_E]

Hi Rabi,

I'm assuming you're referencing this discussion forum? I think they were using the Agilent Technologies IntuiLink 16700 Software. I checked and we don't have a driver for the Agilent 16700. That would allow you to pull data into your LabVIEW program and then use Write to Spreadsheet or ActiveX calls to save the data to Excel.

I think your best bet will be to use VISA to send and receive data from your Agilent Device unless they have a driver. Let us know how it goes!

[rabishankar]

Yes, Hillary you are correct.I am ussing Agilent Intuilink Connectivity software to communicate with agilent 16700 logic analysis system.This software creates a extra addin toolbar in excel whixh can be operated manually to import data to excel sheet.I have serced about the automation of excel and found that Macros function in excell can be used to automate some manually done steps in excel.Also these macros can be invoked using labview.I am going through the process.lets see woh much I can Proceed.

Thanks a lot for your followup.

Regards

Rabishankar

STMicroelectronics

[rabishankar]

Another issue is up now.I am trying to use Macro function of excel to extract data from LAPG to excel sheet.While doing so i am getting run time error 9 in excel sheet which restricts me from creating my desiired marco.Does any one of you have any idea about this error in excel??

Looking forward to your suggestion.

Rabishankar

[Hillary_C_E]

Hi Rabishankar,

I don't know anything about your error in the Excel sheet. You might want to look in the Microsoft help for more information and troubleshooting.