Dropping an Excel object

[Hans Plass]

I have suddenly encountered a problem when trying to drop or delete an Excel object (after checking that REF(object)=1), even though there have been no program code changes. Indeed, the process becomes interminable, so that it is only possible to conclude it by killing it via the Task Manager of Windows. The only environmental change that has occurred recently has been the disconnection of the stand-alone computer from OneDrive, if that has any bearing on the anomaly. I would be grateful for any hints or suggestions that might help to resolve this problem. Thanks in advance
Hans Plass
Sistemas 4u2 - Chile

[Arno de Greef]

Hi Hans,

This sound like what happens when a file has not been synchronised from Onedrive to your machine. The system finds the file exists but when you try and open it from within PxPlus there's no content in the file, so Onedrive needs to download it. If there's no Onedrive connection processes may hang-up.

Cheers,
Arno de Greef

[PxPlus]

This sounds like Excel itself is hung up trying to update oneDrive.  Its possible it is trying to upload any changes you have made (or maybe something as trivial as the last accessed date) on oneDrive.

Also make sure you has closed all the excel workbooks before you drop the Excel object. 

[Hans Plass]

Thanks for your help, Arno and PxPlus. I have tried the method CloseWorkbooxs() but it hangs the same way as the dropping. How could I go on using my program as before I disconnected OneDrive without having to reactivate it. Or is that not possible? Thanks again, in advance.

Hans Plass
Sistemas 4u2 - Chile

[Arno de Greef]

It's hard to give advise without a more details about your program.

In general, I think this will take a bit more debugging. Assuming Excel is working normally outside PxPlus and this issue is Onedrive related, I would probably start by (temporary) placing the Excel file on another disc (surely outside Onedrive). Just to see what happens.

Cheers,

Arno de Greef

[Hans Plass]

Thanks for your help, Arno. I’ll give it a try.

Cheers
Hans