Excel Copy Method Works Only Sometimes

[albertm]

Hi,

The copy method only works sometimes for me.  If you run my attached VI and press the Run button a few times you'll see that it sometimes says "It works" in Table 2.

Thanks,

Albert

[RDR]

What  ActiveX object is used within your 'Table 1' and 'Table 2' controls.  These show up as 'Control could not be loaded' on my end.

-Bob

[albertm]

Hi,

It seems to be working now all the time.  I thought I had rebooted before making my example and seeing it not work.  It must be something I'm doing elsewhere that's messing up something.  I'll be debugging stuff around similar code today and maybe it'll show up again.  It would still be nice to have someone look at my code to see if I'm missing something.

The ActiveX objects are both Microsoft Office Spreadsheet 11.0.

Thanks,

Albert

[RDR]

Hello Albert,

What version of LabVIEW are you using?  In LabVIEW 8.5 I see 'it works' every time I run the VI.

On a side note, if anyone is looking for the Microsoft Office Spreadsheet 11.0 control you can get it from Microsoft here:

http://www.microsoft.com/downloads/details.aspx?familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displa...


-Bob

[albertm]

Hi,

I'm using LabVIEW 8.2.1 at work and at home.  It always works for me at home and I figured out that at work I have the problem only when the Office Cliboard thing is opened.  I have have Microsoft Office 2003 at home and at work.  I'll compare my version number of Office with the one and I guess I'll see if there are any updates.  I assume you don't have Microsoft Office because you didn't have the Spreadsheet thing already installed.

Thanks,
Albert

[RDR]

I have Microsoft Office, but I have 2007 versus 2003.

-Bob