Re : Using an Excel macro in LabVIEW

[Devour]

I think I don't see what is really a template.

You can see what I tried with Jpeg attached. But the macro still work on the current file which is Macro_graphe...

The best things would be :

1.to write the macro directly in the file

2.to say to the macro that it works for a special file

3.convert the macro into LabVIEW language

I don't find solution, it is difficult but look like easy 😛

[EvenDeejay]

See my last post on page 2 in this thread. I think we posted almost at the same time.

Edit: I might not follow you on this one, but if you got alot of macros, you can save them all in the template.xls file. Then choose wich macro to run from LabVIEW.

[EvenDeejay]

I'll try to explain a bit further about what a template is:

A template is a predefined, preformatted shell that you can copy data into and save as new file with a new name.

I usually just open Excel and starts formatting the cells. You know, color, font size, pictures and formulas. Then I save it on my computer or the server. I haven't done nothing with LabVIEW yet.

Then I create my program in LabVIEW. I use the "Copy file" function and copies the template file and save it to a new location:

For example:

This repeats everytime I create a report. The good thing about this is that I can do all the formatting and macros, etc in the template. If I ever need to change anything I just change to template. 

[Devour]

Oh yes, in fact I see ! It's like a model that we can copy and rename as we want.

This idea is good. The problem is that my program is big and it's difficult to put all of this inside, and there are some problems to convert the data.

My .xls file is generated by LabVIEW like a .txt file, and it contains a row of Title's columns, 9 columns of data and many rows of data numbers.

I think I have found a solution. Use Run Macro Excel and arguments with a template file. The argument will be the path of the file to be analysed.

No ?

Anyway, thanks so much for your help DJ ! You are helpful !

[EvenDeejay]

You are correct You can send arguments along with the macro name.

I'm happy to help! Good look with your work 

[simon76]

Hi EvenDeejay,

Do you have the _excel.zip in 2009 format as i cannot open it.

thanks and regards,

Simon

[$anman23]

Hi 

Mansi here

I m doing a project on "warehouse monitoring system using wireless load cell".

In this i have to do only stock management. For that want to make excel sheet. the excel sheet 's format is attached.

Nw confused in how to make this excel sheet. What should i use? LV, Excel Macro or both's combination. Pl hepl me out, done so much search but nt get sucsses.