String and Array maximum length

spacko

New Member
Joined
Jul 25, 2011
Messages
1
Hi there,
I'm sort of stuck. What I'm having to do is do read out data from a logging device via a serial port. I have managed to read data from the port into excel, I'm just not sure of the method to use when it comes to evaluation

It's quite a number of values I have to read, about 30000 mostly consisting of three digits and a comma.
I can't read all at once due to the limitation of the buffer size.
My idea of solving the problem is as follows:

1. read out data as long as data are streamed
2. add up the read data into one single large string
3. split into array by comma
4. since the streamed data are representing 6 channels, I'll have to transform that one-dimensoned array into a two-dimensional one with one dimension having 6 values (to become 6 columns later)

Is this a promising way? Can Excel handle string variables and arrays of this size (even excel 2003)?

Thanks for looking at it

Steffen
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
It's quite a number of values I have to read, about 30000 mostly consisting of three digits and a comma.

Can Excel handle string variables and arrays of this size (even excel 2003)?

Hi Steffen
Welcome to the board

I don't think the size of the string will be a problem since vba can handle strings up to 2 billion+ characters (2^31) ;)
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,289
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top