Please make your question more clear! And sample of code would be nice too
But, I think you have the solution already...Don't set your Excel object to Nothing until your done with adding all your pagebreaks

----- usiddiqui wrote: ----

Hello , All

I am working on a project to convert text files in to excel files.

I generated my excel sheets successfully, in the end i set the
page breaks for the excel sheets. But i am getting a problem,

When i generate the first sheet sheet the page breaks are set with n
issue. After that i destroy the excel object from the
memory.


But when i again generate another sheet. the page break setting
codes gives problems...

I am pointing this thing again that i had cleard the memory
with the excel object.

Please Help : ,

Regards


--
Message posted from http://www.ExcelForum.com