Need a Concatenating VBA code to prevent memory issue workaround

Posted by doharr on Stack Overflow See other posts from Stack Overflow or by doharr
Published on 2009-12-06T22:04:48Z Indexed on 2010/05/12 7:04 UTC
Read the original article Hit count: 187

Filed under:

string-concatenation

|

concatenate

|

vba

My set up: Have 50,000 rows of data. ( My row count will increase in the future. So might as well say I have a full worksheet of 64000+ rows.) All Data is TEXT, no formulas, etc.

Column A is open Columns B thru AC contain the Data that needs to be concatenated The Data in the rows once concatenated to Column A will contain 60,000 digits or 6kb in file size. After additional maniuplation each cell will become a file.

I have tried concatenating in Excel and I run into memory issues. The memory issue is when I Select and fill down the concatenating function into the worksheet. It crashes at the 8200 +/-row. My system is 2gb of ram, windows xp professional and Excel 2003. Have 4GB of disk space

Hoping to find a VBA code that will conserve memory, and not crash like it does in excel.

Thank you

© Stack Overflow or respective owner

Related posts about string-concatenation

vb.net string concatenation string + function output + string = string + function output and no more

as seen on Stack Overflow - Search for 'Stack Overflow'
The following output produces a string with no closing xml tag. m_rFlight.Layout = m_rFlight.Layout + "<G3Grid:Spots>" + Me.gvwSpots.LayoutToString() + "</G3Grid:Spots>" This following code works correctly m_rFlight.Layout = m_rFlight.Layout + "<G3Grid:Spots>" + Me.gvwSpots.LayoutToString() m_rFlight… >>> More
Difference in String concatenation performance

as seen on Stack Overflow - Search for 'Stack Overflow'
I know you should use a StringBuilder when concatenating strings but I was just wondering if there is a difference in concatenating string variables and string literals. So, is there a difference in performance in building s1, s2, and s3? string foo = "foo"; string bar = "bar"; string s1 = "foo"… >>> More
String concatenation within INFORMIX-SQL "Perform" screens.

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! >>> More
t-sql string concatenation

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a table that has following column Type -------- type 1 type 2 type 3 How can i convert the above to a string like ('type 1', 'type 2', 'type 3') I want to use the output in my t-sql query with IN clause. Something like select * from TableA where SomeColumn IN ('Type 1','Type 2', Type 3') I… >>> More
how to create a string literal as a function argument via string concatenation in c

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to pass a string literal to a function myfunction("arg1" CONSTANT "arg1"); now part of that constructed string literal needs to be a function return stmp = createString(); myfunction("arg1" stmp "arg2"); is there any way to do this in one line? myfunction("arg1" createString() "arg2");… >>> More

Related posts about concatenate

How do I concatenate 2 strings in NSIS

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I concatenate 2 strings in NSIS? >>> More
Linux command to concatenate audio files and output them to ogg

as seen on Super User - Search for 'Super User'
What command-line tools do I need in order to concatenate several audio files and output them as one ogg (and/or mp3)? If you can provide the complete command to concatenate and output to ogg, that would be awesome. Edit: Input files (in my case, currently) are in wma format, but ideally it should… >>> More
Concatenate row values T-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to pull together some data for a report and need to concatenate the row values of one of the tables. Here is the basic table structure: Reviews ReviewID ReviewDate Reviewers ReviewerID ReviewID UserID Users UserID FName LName This is a M:M relationship.… >>> More
Ruby concatenate strings and add spaces

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 4 string variables name, quest, favorite_color, speed that might be empty. I want to concatenate them all together, putting spaces between those that aren't empty. So: name = 'Tim' quest = 'destroy' favorite_color = 'red' speed = 'fast' becomes 'Tim destroy red fast' and name = 'Steve' quest… >>> More
Concatenate javascript to a string/parameter in a function

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using kottke.org's old JAH example to return some html to a div in a webpage. The code works fine if I use static text. However I need to get the value of a field to add to the string that is getting passed as the parameter to the function. var xmlhttp=false; /*@cc_on @*/ /*@if (@_jscript_version… >>> More