| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| I am using lotus script to embedded an Excel object. The script is doing a loop (10 times). It process the data and embeds the Excel object to the document, but next document does not embed the object and process data. On the third loop, it processs the data and embed the Excel object. Sometimes it will process alternate time (1,3,5,7,9). I inserted print lines to code to see what is happening. It seems to skip a line in the code (Set object = rtitem.EmbedObject(EMBED_OBJECT,"",ExcelFileName$,"Analysis"), but when I insert a message box line before this line it runs correctly. The only problem with this is user has to click ok button of the message box 10 times. I have used Sleep() syntax, but it did not work. Is there a way to for the script to stop skipping the line. Any suggestions will be helpful. Thanks. |
![]() |
| Thread Tools | |
| Display Modes | |