Outlook version of Excel command?

Status
Not open for further replies.
Dr. Demento

Dr. Demento

Member
OS Version(s)
  1. Windows
Outlook version
Outlook 365 64 bit
Email Account
Office 365 Exchange
Is there a Outlook version of Excel's Application.DisplayAlerts = False? I'm repeatedly overwriting an excel file from Outlook and don't want to deal with the "Are You Really Sure You Want To Do This?" dialog box
 
Michael,

I appreciate the response.

I'm getting conflicting messages. My first thought is that the dialog is from Outlook because Outlook VBA is writing to a closed Excel workbook and the Excel application has yet to be launched. However, the dialog box title is "Microsoft Excel" (see attached).
Excel Dialog.JPG
Since the VBA is operating exclusively from Outlook (source code - altered to write to a set filename with current date, where strFil InputBox is replaced with strFile = "H:\Documents\_Shortcuts\Outlook Item List_" & Format(Now, "yyyymmdd") & ".xlsx"),
I'm confused as to how 1) the dialog is coming from Excel if Excel isn't even "running" and 2) how would I put code in Excel to alter the behavior that originates in Outlook.
[DOUBLEPOST=1444230435][/DOUBLEPOST]Diane,

I was hoping to be able to suppress the warning from Outlook using an analog of DisplayAlerts = False.
 
It doesn't matter where the code is running. You most likely call Workbook.Save*, so you're calling a method of the Excel library.

Workbook.Application refers to the Excel application object, so it's pretty simple: Workbook.Application.DisplayAlerts=false

You just need to insert the variable name you use for Workbook.
 
That worked perfectly! Thank you!!!
 
Status
Not open for further replies.
< .msg file saved in network drive appearing in Deleted Items folder | Cannot Delete Emails from IMAP inbox >
Similar threads
Thread starter Title Forum Replies Date
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 2
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0
J Hotmail drafts started on desktop disappear, but show in web version of Outlook Using Outlook 4
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 27
J Outlook EAS protocol version Using Outlook 1
cheapfaremart Which outlook version is best? Using Outlook 0
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
M White square in body of Outlook Messages (O2016 Version 2012 32bit Click To Run) Using Outlook 4
S Is there a free version of outlook? Using Outlook 0
A Backup Email Accounts On OutLook For Mac 2016 (Microsoft 365 subscription version) Using Outlook 0
M Desktop Version Of Outlook Generating Error Using Outlook 4
Diane Poremsky Outlook for Mac Version Numbers Using Outlook 0
E Want to Import Outlook 2003 pst files to later version Using Outlook 6
M file attachments is not shown in outlook version Using Outlook 2
G Address names auto complete not working - Outlook 2007 version Using Outlook 1
B Outlook Version Outlook VBA and Custom Forms 1
N How to know the version of outlook version Outlook VBA and Custom Forms 1
L Android Outlook Doesn't Update PC Notification Changes Using Outlook 0
A How to open Excel file saved in Outlook folder? Outlook VBA and Custom Forms 4
D.Moore Outlook desktop client suggested searches question Using Outlook 10
Y Outlook 2016 (64-bit) Copy Local Cal. Events to Another Cal. with Modified Reminder time Using Outlook 2
T Outlook 2019 While connecting an IMAP account in "classic" Outlook 2024 I caused a massive duplication of emails on the server (death loop) Using Outlook 5
D Cannot logon to Outlook.com, or outlook on Mac, outlook not updating on ipad, iphone Using Outlook 1
J unable to get my new install of Outlook to display mailboxes in the single-line format. Using Outlook 1
D Legacy Microsoft Outlook for Mac Support will end in Oct 2025 Using Outlook 5
C Nasty Bug Lurking In Outlook For Years. The Trigger. Any Fix Or Workaround? Using Outlook 11
R Auto clicking Hyperlink in outlook Outlook VBA and Custom Forms 7
ughlook Open multiple contacts in NEW Outlook? Using Outlook 3
G Outlook translation feature is off Using Outlook 2
J Outlook 2010 does not let me put any account Using Outlook.com accounts in Outlook 3
P 3 of 5 PST files don't install from d:\outlook but only from D:\ Using Outlook 7
HarvMan January Windows 10 preview update force installs new Outlook Using Outlook 1
L Outlook 2010 - new installation on Windows 11 - aplzod32.dll is not a valid Add-in Using Outlook 12
J Outlook troubleshooting/logging - option grayed out Using Outlook 2
B Arrows missing from Outlook emails vertical scrollbar Using Outlook 0
G Outlook 2021 (New) doesn't respect default browser Using Outlook 9
B Outlook or iPhone turning tabs into spaces in Outlook Notes Using Outlook 1
P newly installed Office 365 includes OLD Outlook Using Outlook 6
R Outlook ribbon menu default? Using Outlook 7
H Spam email in Gmail not visible in Outlook Using Outlook 3
J How to transfer Win 10 Outlook to new Windows 11 pc? Using Outlook 16
J Renegade spam URL line displayed in old local Outlook 365 email title Using Outlook 3
G Reduce whitespace in Outlook desktop Contact Cards display Using Outlook 3
C Outlook classic via 365 Using Outlook 2
Dr. Demento Analogous Outlook code to read info into an array (or collection or whatever) Outlook VBA and Custom Forms 7
S Repair Outlook Using Outlook 8
V Outlook Form ListBox is not editable Outlook VBA and Custom Forms 2
F Outlook's contacts Using Outlook 1
D Outlook 2003 stopped dead Using Outlook 2
G Cannot receive emails from gmail account in Outlook 365 Using Outlook 1

Similar threads

Back
Top