Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Excel to Give Lotus Note attachment focus

Status
Not open for further replies.

Bass71

MIS
Jun 21, 2001
79
I have what I think may be a Lotus Notes issue;but I am automating the printing of excel attachments from Lotus Notes. Using Sendkey function from exel macro, I have just about automated the whole process however, when I attempt to launch the attachment, (I need to print it) the focus always remains on the workbook with the macro. I literally have to leave the launch as the last command in the sub routine and then run an additional macro to take care of the rest. I've tried Application.Wait
End
Exit etc...but I can't pause this thing to give the attachment the focus

Thanks..............RO
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top