Problem trying to self-update file

[bagullo]

Hi,

trying to implement a self-updating excel file structure
each file contains an ID of file type
when opens, checks if a new version exists. If so, saves intself into a backup folder, opens template, saves on top of the original location.

If I execute the macro, all works fine.
However, this macro must run with the event "Workbook_Open" and for some reason, excel blocks the file??
Anybody found this problem?
any workaround?

Please Login or Register  to view this content.

[bagullo]

The same approach with a test file does work perfectly, it seems it has something to do with file size and the fact it's still opening and so.
maybe it has to do with the fact it has lots of macros and a custom ribbon.
Is there any way to wait for the workbook to be completely loaded before running themacro but still do it on start up or connected with start up?

[bagullo]

FWIW apparently the solution is delaying the execution with Application.onTime
this appears to solve the problem so far