Sorry on the last thread... site did not respond when I submited.

I am attempting to do the following... but I cannot figure out a coupl
of the steps..

1. I am making a copy of a worksheet from a workbook, starting a ne
workbook.. and doing a paste special values into the new workbook..
either need the new workbook to come up with just one sheet or I nee
to delete all blank sheets... when I have attempted this I get th
dialog box that says the deletion will be pementant. which I want it t
answer ok and go on... but how..

2. I need to do a save as to a new file name and want it t
automatically select the contents of a specific cell or combination o
cells for the file name to assign.. again how

3. I am saving it as a csv file.. but again I have dialog boxes I nee
it to get arround...

Thank you for your help!

Rand

--
RANDY IN N
-----------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...fo&userid=2977
View this thread: http://www.excelforum.com/showthread.php?threadid=49624