How to check opened excel file closed or not from Navision

upasanisandip

Hi,
I have opened excel file from Navision (used 'Microsoft Excel 11.0 Object Library'.Application). Now I want to check whether that file is closed or still open from Navision.

Is it possible?

thanks,
sandip.

kine

You can try to open it for writing. If it fail, it is still opened. May be it will work.

upasanisandip

Thanks kine,
But my problem is different, I want to delete that file if it is closed.
I only want boolean value , files is closed "True" or "False"
If you know about Handler or sample code is threre (for excel application) then plz. post it.

many thanks

kine

The reult is True/False if done correctly. You can than use it in a loop or timer to check it and delete the file if you find out that the file is accessible.