Hello,
I'm experimenting with unbound object frames to embed an excel sheet in Access. So far it worked pretty well but I noticed an issue:
If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything until excel stops being busy.
Is there a work around of some kind? My users will probably be running excel vba programs when they attempt to view this form, if there is no work around I'll have to drop the idea of embedding excel in access.
I'm pretty sure the issue comes from how excel behaves, whenever an "external" thing wants to use excel (opening a file in explorer, etc), it uses the very 1st excel application open on the computer at this moment, instead of creating its own instance, or at least scanning for how busy the open application is. Because of that, I think that even loading the preview in the access form will try to use the current excel process even though it's completely busy.
Any ideas?
I'm experimenting with unbound object frames to embed an excel sheet in Access. So far it worked pretty well but I noticed an issue:
If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything until excel stops being busy.
Is there a work around of some kind? My users will probably be running excel vba programs when they attempt to view this form, if there is no work around I'll have to drop the idea of embedding excel in access.
I'm pretty sure the issue comes from how excel behaves, whenever an "external" thing wants to use excel (opening a file in explorer, etc), it uses the very 1st excel application open on the computer at this moment, instead of creating its own instance, or at least scanning for how busy the open application is. Because of that, I think that even loading the preview in the access form will try to use the current excel process even though it's completely busy.
Any ideas?