AnsweredAssumed Answered

Help : new to VEE

Question asked by Hanni on Apr 15, 2020
Latest reply on Apr 17, 2020 by Stan Bischof

Like • Show 0 Likes0
Comment • 5

Hello,

I am a new user to VEE programming. I just started last week. I am stuck with few problems. Can someone please help me with the error.

I measure the current for a count of 705. After that I want to send the values to excel. I get an error code of 830 when i try to do this. I directly write the variables (allocated as array initially) into the excel. Is the syntax different for writing the array into the excel?

Also can you please tell me how to access the excel using the ActiveX command Get object?for ex: GetObject("xxx","Excel.Sheet").worksheet.xls is this correct?

Thank you for your help

Regards

Hanni

No one else has this question

Outcomes

uWHarry

Apr 15, 2020 7:36 AM

Error code 830 is "Could not initiate DDE link to application". Did you run the Initialize Excel Library block at the start?

There are a bunch of example programs for Excel included with VEE. Look under File / Open Example / Excel Library / SendingData.

1 person found this helpful

Actions

Hanni @ uWHarry on Apr 15, 2020 11:14 PM

Hello Drew,

Thanks for the reply. I could make the communication work. I have one more question, my variables are an array and i want the data to be saved into different rows in the excel. It send all the data to a single row now. I used a "\t" or "\v" separator in the To/From DDE. What am I doing wrong?

Thank you

Actions

uWHarry

Apr 16, 2020 7:20 AM

Hanni; Please attach a sample vee program to show me what you're trying to do. Just have it create the excel sheet and send some data to it in the format you are using and I'll try to figure out why it's all jammed together. It may be as simple as changing the separator. I'm stuck at home with my laptop, so I'll be glad to give it a try.

Actions

Hanni @ uWHarry on Apr 17, 2020 7:39 AM

Thanks Drew and sorry for a late reply.

here's the screenshot from VEE and excel, Column B,C&D gets data from Pass,iststrom,istbasis. It just needs to be written into different cells row wise.

Thank you for the help.

Actions

Stan Bischof @ Hanni on Apr 17, 2020 10:36 AM

Hard to tell definitely from your screenshot, but your "repeat 705" would appear to be a loop, in which case you are sending scalar items, not an array as your original note implied. To get a 2D array in Excel, you could create an array first and then send it, or increment the Excel indicies as appropriate.

Stan

PS-I should note that the Excel Library was written to address the arcane interface to Excel, and it works pretty nicely. If feasible you may want to go that route rather than implementing the interface yourself.

Actions

5 Replies

uWHarry Apr 15, 2020 7:36 AM
Mark Correct
Correct Answer
Error code 830 is "Could not initiate DDE link to application". Did you run the Initialize Excel Library block at the start?
There are a bunch of example programs for Excel included with VEE. Look under File / Open Example / Excel Library / SendingData.
1 person found this helpful
Like • Show 0 Likes0
Actions
- Hanni @ uWHarry on Apr 15, 2020 11:14 PM
  Mark Correct
  Correct Answer
  Hello Drew,
  Thanks for the reply. I could make the communication work. I have one more question, my variables are an array and i want the data to be saved into different rows in the excel. It send all the data to a single row now. I used a "\t" or "\v" separator in the To/From DDE. What am I doing wrong?
  Thank you
  Like • Show 0 Likes0
  Actions
uWHarry Apr 16, 2020 7:20 AM
Mark Correct
Correct Answer
Hanni; Please attach a sample vee program to show me what you're trying to do. Just have it create the excel sheet and send some data to it in the format you are using and I'll try to figure out why it's all jammed together. It may be as simple as changing the separator. I'm stuck at home with my laptop, so I'll be glad to give it a try.
Like • Show 0 Likes0
Actions
- Hanni @ uWHarry on Apr 17, 2020 7:39 AM
  Mark Correct
  Correct Answer
  Thanks Drew and sorry for a late reply.
  here's the screenshot from VEE and excel, Column B,C&D gets data from Pass,iststrom,istbasis. It just needs to be written into different cells row wise.
  Thank you for the help.
  Like • Show 0 Likes0
  Actions
  - Stan Bischof @ Hanni on Apr 17, 2020 10:36 AM
    Mark Correct
    Correct Answer
    Hard to tell definitely from your screenshot, but your "repeat 705" would appear to be a loop, in which case you are sending scalar items, not an array as your original note implied. To get a 2D array in Excel, you could create an array first and then send it, or increment the Excel indicies as appropriate.
    
    Stan
    
    PS-I should note that the Excel Library was written to address the arcane interface to Excel, and it works pretty nicely. If feasible you may want to go that route rather than implementing the interface yourself.
    Like • Show 0 Likes0
    Actions

Help : new to VEE

Outcomes

Related Content

Recommended Content