Write Spreadsheet to String Array on another worksheet

[krispiekream]

thanks,

i will take a look at it.

[krispiekream]

Message Edited by krispiekream on 06-03-2010 05:54 PM

[smercurio_fc]

And you're posting that library because ...

[krispiekream]

i was going to ask a question, so i posted the llb.

but i decided to edit and remove it till i find out my own solution.

you guys are great at answering my questions and are very helpful though.

i havent figured out how to do it yet, but i will soon (hopefully)

[krispiekream]

THANK YOU!!!

I did it using ActiveX.

But my code doesnt look pretty

[tbob]

Why don't you post your ugly code.  I could use a good laugh right now.

Seriously, I would like to see it.  I learn from these things.

[krispiekream]

Alright, Here it goes.

I can successfully create new worksheet with raw data.

but my code is a mess.

BUT I HAVE 1 MAJOR PROBLEM.

everytime I tried to SAVE. It wouldn't save the two worksheets I have.

can someone help me?

[krispiekream]

What do I need to put in the ActiveX Save As function for

Microsoft Excel 97- Excel 2003 & 5.0/95 Workbook (*.xls)

 ????

[tbob]

WOW.  You were right about it not being pretty.  You really should break this up into subvi's and a state machine.  Maybe put all of your string variables in a cluster.  This will be a nightmare to troubleshoot and maintain.  Please consider changing it.

As for your saving problem, your code to close and quit Excel is in a separate loop.  This loop will run continuously in parallel with the rest of your code.  I don't think this is what you want.  A state machine would solve that problem.

[krispiekream]

i will try to make it to subvi as soon as I get everything working.

what do i need to put in the text "text.xls" to save it in .xls format?