Excel Object remains in the memory

[jgandhi]

Hi All,

I am doing VBA Programming in excel using office 97.I have created excel object as follows

Dim objexcel As Excel.Application
Dim objwb As Excel.Workbook
Dim objsh As Excel.Worksheet
Dim objshMI As Excel.Worksheet


Inspite of closing the workbook and setting all the object to nothing when I press ctrl+Alt+del it always shows one excel object in the memory.
I am closing the wb and setting the object to nothing in following order

objwb.Close savechanges:=False
objexcel.Application.Quit
Set objexcel = Nothing
Set objwb = Nothing
Set objshMI = Nothing
Set objsh = Nothing


Thanks & Regards,

Jignesh

[RobDog888]

Try changing the order.

objwb.Close savechanges:=False 
objexcel.Application.Quit 
Set objshMI = Nothing
Set objsh = Nothing
Set objwb = Nothing 
Set objexcel = Nothing

[jgandhi]

Thanks for the reply but even after changing the order things are not working as required.

One thing which I found out is that this problem occures only when the data file i.e. excel file is a big say around 2500 rows if I reduce this to 1000 rows everything works fine, there is no excel object in the memory.

So is there any problem in working with large excel file.My system config is windows 98,256 MB RAM

Thanks in advance

Jignesh

[RobDog888]

Sound like a timing issue. When there are allot of records it is
taking Excel longer to close and the code is destroying the
objects before it should. Try adding a delay or check to allow
Excel time to close.

[jgandhi]

Hi,

Thanks for the reply.But actually what is happening is that things are working fine on the OS2000.The problem happens only on 95 and 98 machine.So is there any issues while working with larges excel file on 95/98 OS.
If any then please let me know and also if u know the workaround.

Thanks in advance

Jignesh

[RobDog888]

Are the 95/98 machines running the same version of Excel?
If not check and make sure that all methods and properties are available.