Receiving Server Busy message when BusinessObjects displays the Publish To Coporate Documents window that allows a user to select which group to export the document to. The Publish to Corporate Documents window is activated from within VBA using the Send method. When a user clicks anywhere else on the screen, the Server Busy message appears. Is there anyway to avoid this?
in ur case vba is OLE client and BO acts as OLE server. When u execute doc.send, if the parameters u have is not sufficient then BO (ole server) displays dialog box in Modal mode. At this time time, you have to close the window by pressing OK or Cancel, only then control goes back to ur OLE client (VBA application). This is OLE limitation. One way is, you can design your own dialog box in VBA to accept all the parameters to schedule a document
Vasan
Baton Rouge International Inc
data Warehousing
Receiving Server Busy message when BusinessObjects displays the Publish To Coporate Documents window that allows a user to select which group to export the document to. The Publish to Corporate Documents window is activated from within VBA using the Send method. When a user clicks anywhere else on the screen, the Server Busy message appears. Is there anyway to avoid this?