Error 70 Permission Denied causing Issues

[ppynrde]

The code I am developing creates multiple instances of Excel within VB to allow different spreadsheets to be viewed in parallel. For each of these objects I am creating a new instance of Excel so that they are entirely self contained. Everything is working as expected the majority of the time. However, on certain occaisions, the frequency of these depending on the host machine, I am receiving 'Error 70ermission Denied' errors when my code tries to create the Excel Object using the CreateObject syntax. The only way I can seem to get around this is to log out and back in again. Any ideas on this would be a great help as it is causing many headaches.

I am running Win2k and VB6 sp5.

Thanks in advance

 

[Sawatzky]

dear ppynrde,

perhaps it is caused by a memory leak.

you could try to find out, if the number of instances running is the number of instances you expect to run, by watching the task-manager. ( Be aware that it really makes a difference if you run in debug mode or not. So run your compiled application.)

HTH

regards Astrid