Excel Border Line style works for the first time I run the code, later it shows some error

Hi,

I am trying to generate a automatic report in excel format by using VB6.

To draw borders in the excel file, I recorded a macro in one excel and found out the syntax from there.

It works perfectly for the first time, and if dont end the program and try to generate another report it gives me an error which says "The remote server machine does not exist or unavailable".

Anybody please help me with this..

Error message highlights the first line of this code.

Please Login or Register  to view this content.

Try replacing all of that with this:

Please Login or Register  to view this content.

If you are doing this in VB6, you aren't properly qualifying your Excel objects, which means you end up with an implicit Excel reference that can't be destroyed until your program terminates and that's why it remains in memory. You should have something like:

Please Login or Register  to view this content.