IceBox Posted July 24, 2006 Report Share Posted July 24, 2006 Hey guys. I think I got a real mystery here. I posted something about this already in this forum WAY back in January 2005. The link is HERE Rather than start over, please read that post first and then I will continue from there... Anyway... now this has gotten a bit trickier. I have created 2 different macros that attempt to press "n" for the notify button when the "File In Use" box pops up. One is the actually macro that I need this to apply to, and the other is a very short macro designed only to test this particular problem. When I run the "real" macro, it hangs up when that box appears. The script looks like this: <GETCONTROL2:01:NLNOTES.EXE:#32770Lotus Notes001:11IRIS.password><GETCONTROL2:11:EXCEL.EXE:bosa_sdm_XL9File in Use000:><GETCONTROL2:12:EXCEL.EXE:bosa_sdm_XL9File Now Available000:><GETCONTROL2:13:EXCEL.EXE:#32770Microsoft Excel001:2Button><MENU2:1:T:01:CenterCenter:Week SelectionWhich week would you like to lock?1 2 3 4><TMVAR2:05:01:01:000:000:><NMVAR:02:01:1:0000001:2:0000001><IVAR2:02:02:FLast file completed?FFCenter:Center><REP3:08:000002:000002:0003:1:01:N3><NMVAR:01:02:1:0000002:2:0000001><TBOX4:F:6:0Right000Top000124000097:000:File#%N2%><TVAR2:02:08:\\uhc00548\homedirs\mluppen\Production Files\Lock.inilock%N2%a><TVAR2:03:08:\\uhc00548\homedirs\mluppen\Production Files\Lock.inilock%N2%b><TMVAR2:01:02:00:000:000:><TMVAR2:01:03:00:000:000:><IFVAR2:1:02:1:><TMVAR2:01:10:00:000:000:><IFVAR2:1:10:2:><TMVAR2:17:10:00:000:000:\\uhc00548\homedirs\mluppen\Production File Error Report\Error Report.txtF><ENDIF><MSTOP><ENDIF><IFOTH:01:2:\\uhc00548\shared\Office Production\%T2%\%T3%><LAUNCHDEL2:0:01\\uhc00548\shared\Office Production\%T2%\%T3%2><DELAY:5><IFCONTROL:03:11><TEXTTYPE:n><DELAY:2><LAUNCHDEL2:0:01\\uhc00548\shared\Office Production\%T2%\time tracker.xls2><WAITCONTROL:000010:000000:13:02><CCLICK:T:13:0:T:><DELAY:2><TEXTTYPE:<ALT>tpp><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><TEXTTYPE:<CONTROL><HOME><CONTROL>f><WAITWIN2:000010:000000:Find><MSD:250><TEXTTYPE:scheduled<ENTER>><MSD:250><TEXTTYPE:<ARROW DOWN><ENTER>><MSD:250><REP3:08:000007:000001:0007:1:01:T3><TEXTTYPE:<ARROW DOWN><F2><SHIFT><HOME>><CLIPC><TVAR2:07:03:><TMVAR2:01:07:00:000:000:><TEXTTYPE:<ESC>><ENDREP><TEXTTYPE:<ARROW LEFT>><CLIPC><TVAR2:08:03:><TMVAR2:01:08:00:000:000:><IVAR2:08:13:8:,><TEXTTYPE:<CONTROL><HOME>><MSD:250><TEXTTYPE:<ALT>tpp><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><TEXTTYPE:<CONTROL><F4>><MSD:500><IFVAR2:2:08:2:0><NMVAR:02:08:1:0000008:2:0000001><TMVAR2:10:09:08:001:N08:><NMVAR:01:08:1:0000008:2:0000001><TMVAR2:11:08:00:001:N08:><TMVAR2:01:08:00:000:000:><LAUNCHDEL2:0:01C:\notes\notes.exe2><WAITCONTROL:000010:000000:01:02><DELAY:1><ETEXT:A443E519D21E1D0575C49B><TEXTTYPE:<ENTER>><DELAY:15><TEXTTYPE:<ALT>fn<ENTER>><WAITWIN2:000010:000000:New Memo><DELAY:3><SPKEY:0010><TEXTTYPE:%T8% %T9%<ENTER>><DELAY:2><IFOTH:04:2:Ambiguous Name><TEXTTYPE:<ENTER>><DELAY:1><ENDIF><TEXTTYPE:<TAB><TAB>michael luppens<TAB>Production File - ACTION REQUIRED<TAB>><TEXTTYPE:Please close your production file ASAP. There is no need to reply to this message. This email is automated, and will detect when you have closed your file. If you still need your production file open, it will be safe to re-open it approximately 2 minutes after you close it. (Please allow 5 minutes if you are a telecommuter). Thank you. ** PLEASE NOTE: Because this process is automated, it is possible that this email was sent to the wrong person, especially if you have the same name as another UHG employee. If this is the case, please respond to this email and let me know. **><DELAY:5><TEXTTYPE:<ALT>as><DELAY:10><IFOTH:04:2:No Match><TEXTTYPE:<TAB><TAB><TAB><TAB><TAB><ENTER>><DELAY:1><TEXTTYPE:<ENTER><ENTER>%T8% %T9%<SHIFT><TAB><SHIFT><TAB><BACKSPACE><SHIFT><HOME><DELETE><SHIFT><TAB><SHIFT><TAB><BACKSPACE><SHIFT><HOME>michael luppens<ENTER>><DELAY:5><TEXTTYPE:<ALT>as><DELAY:10><ENDIF><WSHUT:Lotus><DELAY:1><ENDIF><REM2:---><WAITCONTROL:000000:000000:12:02><MSD:500><TEXTTYPE:w><DELAY:2><ENDIF><TEXTTYPE:<CONTROL><PAGE UP><CONTROL><PAGE UP><CONTROL><PAGE UP><CONTROL><PAGE UP><CONTROL><PAGE UP>><REP3:01:000001:000001:%N1%:0:01:><TEXTTYPE:<CONTROL><PAGE DOWN>><ENDREP><MSD:250><TEXTTYPE:<ALT>tpp><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><TEXTTYPE:<CONTROL>a><MSD:250><TEXTTYPE:<CONTROL>1><MSD:250><TEXTTYPE:pp><MSD:250><TEXTTYPE:<ALT>l><MSD:250><TEXTTYPE:<ENTER>><MSD:250><TEXTTYPE:<ALT>tpp><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><ETEXT:F30428DCA948F52EDE><TEXTTYPE:<ENTER>><MSD:250><TEXTTYPE:<CONTROL><HOME>><MSD:250><TEXTTYPE:<CONTROL><PAGE DOWN>><MSD:250><TEXTTYPE:<CONTROL>s><DELAY:1><TEXTTYPE:<ALT><F4>><WAITWLF2:000010:000000:Excel><DELAY:1><ELSE><TMVAR2:07:10:00:000:000:%T2%\%T3%-><ENDIF><TBCLOSE:File#><ENDREP> Then I created a short macro just to test it, and it works just fine. That script looks like this: <GETCONTROL2:01:EXCEL.EXE:bosa_sdm_XL9File in Use000:><DELAY:5><IFCONTROL:03:01><TEXTTYPE:n><ENDIF> Can anybody see something in the first code that would cause this not to work? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.