Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data where some cells exceed 256 characters
Is there an efficient way to copy large chunks of excel
data where some cells contain data which exceeds 256 characters, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.542 / Virus Database: 336 - Release Date: 18/11/2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data where some cells exceed 256 characters
What is the inefficient way you are using now? Why do you consider it
inefficient - are you encountering an error/problem? -- Regards, Tom Ogilvy "Stuart" wrote in message ... Is there an efficient way to copy large chunks of excel data where some cells contain data which exceeds 256 characters, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.542 / Virus Database: 336 - Release Date: 18/11/2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data where some cells exceed 256 characters
It's a new situation, that's occurred. The user has 3 workbooks
structured very similarly..... in essence they have many (but not all) sheets with common names. Current code processes each user workbook correctly, creating 3 new workbooks. I'm now trying to write new code that will combine all 3 processed workbooks into a single new book, and where the commonly named sheets are combined: So if the processed books were named Process1, 2, 3.xls and a typical common sheet was named UserData, then I could create a new book and copy the UserData sheets from the processed workbooks (where they exist). If 3 sheets exist with the same name then the new book will have sheets named UserData, UserData(2) and UserData(3). Ultimately there would be one sheet named UserData, where the the contents of UserData are followed by UserData(2) and then by UserData(3). It's this copy process that throws the error when copying a sheet where one cell or more contains more than 256 characters. I haven't actually written a solution, but can only think to test each cell for more than 256 characters before copying the sheet...... or perhaps to copy the sheet and then try to trap the error message and then direct code to deal with that specific sheet. What's the best way to deal with this please? Regards. "Tom Ogilvy" wrote in message ... What is the inefficient way you are using now? Why do you consider it inefficient - are you encountering an error/problem? -- Regards, Tom Ogilvy "Stuart" wrote in message ... Is there an efficient way to copy large chunks of excel data where some cells contain data which exceeds 256 characters, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.542 / Virus Database: 336 - Release Date: 18/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.542 / Virus Database: 336 - Release Date: 18/11/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you exceed 15 number characters in an excel cell? | Excel Discussion (Misc queries) | |||
copy select characters from specified cells. | Excel Worksheet Functions | |||
Footer exceed max characters | Excel Worksheet Functions | |||
Sum of previous offset number of cells not to exceed certain value | Excel Worksheet Functions | |||
how do I ensure that the sum of two cells does not exceed a set fi | Excel Worksheet Functions |