Copy data where some cells exceed 256 characters

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Is there an efficient way to copy large chunks of excel
data where some cells contain data which exceeds
256 characters, please?

Regards.
 
What is the inefficient way you are using now? Why do you consider it
inefficient - are you encountering an error/problem?
 
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.
 
Back
Top