string limitation

Hi, i have the below macro which takes a range of cells in a single column and concatenates the values into a single string. The string is then passed via an ODBC connection to SQL to be used as the variables the "Where" statement. My problem seems to be related to how long the string i am...

I have written a sub to read a text file as a string, edit it, and then write it back to the text file. The problem is assigning the edited text back to the string to write it to the file-it says the string is too long. How can I break up my code so that I can put all of the edited string back...

I have been browsing solutions for this problem but cant figure it out. This code limits the string so the email cuts off the complete text past a certain length. Whats the best workaround for the 255 character limit? Can I create an array http://support.microsoft.com/kb/105416 ? Private...

I'm using ShellExecute to launch my default email application and a macro to collect data and store it to a string to be used as the "body" of my email. The problem is that there my be 30 rows of data to list but once it goes to the email only about 18 rows of data survive the transfer from...