Increase Size Limitation That Can Be Imported to Excel

[Ricky_V.]

I had a customer call in that wanted to be able to increase the limitation that Excel allows us to import. He has found a work around in which he creates a Visual Basic Macro in excel. He uses Active X in LabVIEW to open excel, and this puts the macro into use and overwrites the limitation. He was hoping that LabVIEW could do this for him and others so he would not have to write separate code in Visual Basic.

[altenbach]

Do you have a link to information on what the current limitations are?

How does the workaround work? I always thought there is a size limitation in excel itself.

Is the workaround generic or specific to certain excel versions?

[Darren]

Any idea that has not received any kudos within a year after posting will be automatically declined.