Re: Error code -2146827284 when trying to programmatically...

2004-06-11 Thread analog
Hi, This is what I used and it seems to work. But I have an extra series in there for some reason. Good luck

Re: Error code -2146827284 when trying to programmatically...

2004-03-11 Thread Gavin Braithwaite
Robert, thanks for your suggestions. It looks like the problem was indeed that there was no data in those cells. Since I could set one range successfully on blank data I assumed that was the case generically. Obviously not, and I can't see that documented anywhere. Never mind, I think I have it

Re: Error code -2146827284 when trying to programmatically...

2004-03-11 Thread Robert M
Gavin, I can give you a few suggestions, but it looks like this is an Excel error, and not a LabVIEW issue. msdn.microsoft.com has some excellent resources for the ActiveX controls for Excel. Are you using this vi as a subVI of a larger program? In the code you gave me, the cells you reference,

Re: Error code -2146827284 when trying to programmatically...

2004-03-10 Thread Robert M
Gavin, It appears the code you attached this last time is significantly different from what you attached before. In your =93Create Chart=94 subVI, after wiring Range.Cell2 to Cell2, it seemed to run without errors. When you make that change and run it, does the chart appear as you want it? Have

Re: Error code -2146827284 when trying to programmatically...

2004-03-09 Thread Robert M
Hello Gavin, You are probably getting this error because you are trying to access cells outside the maximum range in Excel. A Microsoft Excel spreadsheet is limited to 256 columns and 65,536 rows. This http://digital.ni.com/public.nsf/websearch/23EF6DD43866726C86256D5C0= 0687E51?OpenDocument>Kno