Hi all
Not sure if this is a simple question or not - is it possible to pass the contents of a userform textbox (which exceeds 255 characters ) to a worksheet cell? It seems to truncate when I try to do so.
I even tried the following, with no success:
Please Login or Register to view this content.
Any suggestions?Please Login or Register to view this content.
Dion
Last edited by mojo249; 01-13-2010 at 10:29 PM.
Truncate? Works for me without difficulty in Excel 2003.
Entia non sunt multiplicanda sine necessitate
Ah! I see. It's not the process of saving the value from the textbox to the cell which truncates, it's the process of emailing the sheet. 512 characters are saved into a cell on worksheet "EmailCH", but running the following script (to email the sheet) causes the string to be truncated to 255 characters:
Any advice would be greatly appreciated.Please Login or Register to view this content.
Dion
Hello mojo249,
If you want the body of the email to be more than 255 characters, you will need to wrap the body in HTML code or send a shorter body with the remaining information as an attachment.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith
When you say wrap the body in html code, do you mean I need to send the sheet as part of the body of the email (such as the code below), rather than as an attachment? The problem is, the recipient need to receive the information as a worksheet so putting it in the body won't work.
Please Login or Register to view this content.
Please Login or Register to view this content.
Never mind - I've found a work around. I've added an extra line in the worksheet - the first 255 characters will be placed in the first cell. The remainder in the second (the 2nd will be hidden if Len < 255):
Thanks for your time anyway.Please Login or Register to view this content.
Dion
Hello mojo249,
If the text length of email body was greater than 255 characters then it would need to be wrapped with HTML tags. From what I see in your post, that doesn't seem to be the case. What is the problem you're having?
Hi Leith
No...it's most strange (to me anyway...).
I've attached a workbook showing the worksheet before and after it's sent by the below code. You can see that cell B23 is truncated to 255 characters....
Dion
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks