labview, reference, excel

[yzqamar]

hello friends, another Problem is this one.
i dont know why but after i hit the run button he gives me this.
how can i fix this?

[GerdW]

Hi yzqamar,

you need to supply a valid Workbook reference…

Please stop informing me by PM for new messages, I already get notifications from the forum… 😞

[yzqamar]

Ok, im sorry,

how i do the valid reference?

[GerdW]

Hi yzqamar,

to learn how to handle Excel references you should play with them by writing a VBA macro within Excel!

You need to:

Open Excel
| open workbook
|  |  open worksheet
|  |  |  play with ranges
|  |  close worksheet
|  close workbook
close Excel

[yzqamar]

so now i did a macro with Excel and save it . what should i do next?

[GerdW]

Hi yzqamar,

you didn't get my point: by doing all this with "VBA for Excel" you learn, when to open any reference and how to close them. (The main advantage here is the easier debugging in VBA!)

Once you learned this you can implement the very same scheme using ActiveX in LabVIEW…

In my last message I sketched the steps you need to implement. All I see right now is the "close workbook" step…