LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Dialog not displayed to the front

Hello,

Could somebody please help me with the following problem we are
experiencing since an Office update?

When I send an document as a MailItem from Excel with VBA (with the
VBA code Send), a safety alert sometimes comes behind the Excel
window: "A program is trying to automatically send e-mail on your
behalf. Do you want to allow this. If this is unexpected, it may be a
virus and you should choose "No"."

When this dialog is not displayed to the front, it is not possible to
respond, so after a view seconds comes another dialog box: "Microsoft
Excel is waiting for another application to complete an OLE action".

It is strange that this problem does not occur on all the computers we
use. What is the solution to get the alert always display to the
front?

We use Office 2000 and Office 2002 (Windows 2000 and Windows XP).

Here is the VBA code that I use:

Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItem(olMailItem)
MyItem.To = ToVar
MyItem.Subject = "Afwezigheidsregistratie " & ActiveSheet.Range("A3")
Set myAttachments = MyItem.Attachments
myAttachments.Add Pad, , 1
MyItem.Send


With kind regards,

Leendert Meijer
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete the "Insert Function Dialog Box" (dialog box only)? TBI''d biker Excel Worksheet Functions 2 April 7th 07 09:18 PM
front end zero Tdilly Excel Discussion (Misc queries) 1 September 1st 05 06:56 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
getting rif of apostrophe in front of ss# jrh Excel Programming 4 February 13th 04 02:08 AM
dialog box displayed when internet connection unavailable nil Excel Programming 2 January 28th 04 10:04 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"