Excel doesn't open properly after running code from Access

[gtaborda]

Hi

I have an Access application which creates excel sheets.
This works perfectly.

However after running this code, if I try to open an excel file by double clicking on any XLS file, it opens Excel partially, leaving the main excel window empty (you can see through what's behind, like the desktop).
It is like a memory problem.

I have set the excel object to nothing to free memory (Set objExcel = Nothing) after running the Access code, but, is there something else I need to do?

This problem never occurs...until I run the Access application, so it is obviously caused by it.
Any ideas ????

thanks

 

[PHV]

Please, post the access VBA code which creates excel sheets.
A most common reason is a lack of qualification of the excel objects (e.g. Selection instead of objExcel.Selection)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gtaborda]

hi there

I have checked the code, all excel objects are correctly done (objexcel.xxxxx)

Any other ideas?

I prefer not to post the code, is several pages long, I don't want to bore anybody....

thanks

 

[PHV]

Double check the Range, Cells, ActiveXxx, Selection, ... objects.