[SOLVED] Run-time error '1004': Select method of Range class failed

[Capo]

To bypass most of that code you can do an .Add for adding the new workbook and then do a .Copy on the one sheet you want telling it the destination of the newly added workbook. Then saveas and your dont.

The only thing is, the data will still be "attached" to the original file. I just want the values/formatting copied over.

Just as a simple example, one of the cells in the sheet I want to copy over is something like: IF(Customer!I5<>"",Customer!I5,"")

But if I just straight copy the whole sheet into the new book, it would become:

IF([name.xls]Customer!I5<>"",[name.xls]Customer!I5,"").

Whereas I just want it to copy whatever the value is at the time of clicking the custom Save button.

If that made ANY sense.