VB code

[muks]

[parthabe]

Hi Alex,

Post that VI here so that somebody does a conversion for you.

Sorry, very faaast internet connection.

Message Edited by parthabe on 10-29-2009 03:36 AM

[alex.]

I tried to use the 'add' function inside, but got error as the attached screenshot.

[DavidJCrawford]

Hi,

Sorry to butt in, chaps. Maybe there is a more straight forward way of doing what you want to do using excel activex automation.

Take a look at this old post of mine. It show a way of calling a VBA procedure using arguments.

E.g. You could provide and source file path and destination file path to the macro procedure as arguments. After that you can read the destination file back into labview.

Perhaps if you posted the excel sheet with the macro we might be able to help you better with this technique.

Would this work for you?

cheers

David

Message Edited by David Crawford on 10-29-2009 09:03 AM

[GerdW]

Hi,

load a LV7.1 version of the vi from here. Seems to be more stable...

[alex.]

Some subvi missing when open the sample.

Also I may want to use dll, since it can direclty get data back.

[DavidJCrawford]

OK, that was explained in the old post.

To get the missing VIs

Open up NI Example Finder and load Excel Macro Example.vi into memory first.

After that you can open my example.

Can you post an example .trc file too, please? Rename it to .dat or another extension that will let you post the file to the forum.

[alex.]

Thanks, but finally there will be no excel involved, so still want to use the dll.

The file is over 10M, too big.

[DavidJCrawford]

OK, cool. Good luck!

[alex.]

I tried to recompile and registered the dll, but when run the vi, still got error as the attached screen.

Any suggestion?