I am writing a macro to document our applications. Part of that macro is getting an image of the charts. I noticed that CopyBitmapToClipboard does not work when the button to run the macro is not on the same sheet with the chart. I have tried activating the sheet before calling the said fuction, but its still doesn't work.
My guess is when i call the Sheet.Activate, it proceeds even if the objects in the sheet is still loading, and thus the CopyBitmapToClipboard fails. Is there anyway to workaround this? I'm thinking of checking for the state of the object and setting up a delay/sleep before calling the CopyBitmapToClipboard. Is there some function to check the state of the sheet object and a delay function in VBScript?