Ren,

Do you have three worksheets in one workbook? Do you want to save them as
separate files? Are there formulas or links involved, or do you want to save
just values? Do you want to save copies? What do you want to have happen to
the original file?

HTH,
Bernie
MS Excel MVP

"Ren" wrote in message
...
Hi to all!

I'm also most completed my project and would like to thank all of you who
help,THANK YOU.

Right now I'm trying to save three sheets.

I need to save
SheetA in C:\ABC\A\SheetA,
SheetB in C:\ABC\B\SheetB,
SheetC in C:\ABC\C\SheetC.

I'm using a button to do this and I'm also working with ExcelXP.

Thanks in advance to all.

Cheers

Ren