Lots of times when you get a missing "end with" statement, it's because you're
missing an "end if" that should come before it. You may want to look there.

You can use:

application.displayalerts = false
'your code to save it
application.displayalerts = true

I've never seen saving a workbook (as a real .xls file) chop any data in a cell.

denny wrote:

I'll be getting back to you as soon as I can show you my progress. Some
things are kind of manual because they are done with the macro recorder
instead of the code. Many times when I try to use the code, it tells me
there is a "with" that needs to be finished or some other instruction that I
don't know its partner or how to make it accepted. You can help me with that
maybe after you see my final product...but first of all,
1. IS THERE A WAY...in the macro... TO ANSWER THE YES AND NO WINDOWS that
come up, say when you are saving a file and it asks if it is okay to save it
on top of another?
2.The only solution I have found to my problem to saving big cells is to not
try and save it as a text file at all. SAVE IT AS AN XLS FILE, and that will
make the text file disappear...but it is chopping my big cells down smaller.
IS THERE SIMPLY A LIMIT (ABOUT 242) FOR THE TEXT IN THE CELLS FOR TEXT AND
FOR COPYING. Excel holds a lot more, tho' it has a limit too.
Thanks for your continued help. I'll let you know when it all works right.

--

Dave Peterson