combine multiple workbooks? overcome 255 character limit?

[Wayne]

I want to combine multiple worksheets from different workbooks into one.
There are text boxes with more than 255 characters that require me to go back
and individually copy all these text boxes...very time consuming. Can I do
it in fewer steps by selecting the workbooks to combine and make one new one?

 

[Luke M]

Why not just select the worksheets you want (You can use SHIFT or CTRL to
select multiple sheets), and then right-click, copy entire worksheet yo your
new workbook. This would transfer the text boxes with the sheets.

 

[NC]

this doesn't overcome the 255 character limit.

Why not just select the worksheets you want (You can use SHIFT or CTRL to
select multiple sheets), and then right-click, copy entire worksheet yo your
new workbook. This would transfer the text boxes with the sheets.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Luke M]

I was able to use this method and copied a text box containg over 3000
characters. (using XL 2003). What error are you encountering?