i want to save in sheets



syntax

strSavePath = "E:\1\1.xlsx.(sheet1)"

not comming

That doesn't make sense - if you add something after the file extension, it may no longer be recognised as a valid Excel file.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

in one excel file inside 3 sheet are there, i want to put data in them

You are not making any sense - as with many of your other threads, this one is very hard to understand. From a review of your numerous threads, it would seem that English is not your native language. You should consider typing the requests in your own language, then:
• use translation software to translate it into english (eg http://babelfish.altavista.com/) before posting here; or
• post on a site where people use your own language.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]