Outlook version of Excel command?

Status
Not open for further replies.

Dr. Demento

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
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
 

Dr. Demento

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
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.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
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
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 9
L Opening People Outlook 2021 Using Outlook 2
e_a_g_l_e_p_i Outlook 2021 not letting me setup my Gmail using pop Using Outlook 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 2
O Outlook - Switch from Exchange to IMAP Using Outlook 0
e_a_g_l_e_p_i Is it possible to have a reminder in Outlook 2021 for every 90 days Using Outlook 3
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
C Advanced search terms for "Outlook Data File" Using Outlook 1
N Reply to Outlook messages by moving messages to a specific Outlook folder Outlook VBA and Custom Forms 1
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
A Outlook 365 (OutLook For Mac)Move "On My Computer" Folder Items From Old To New Mac Computer Using Outlook 3
H Integrating Alexa & Outlook Pro 2021 Using Outlook 2
Z Automatically adjust Outlook Reading Pane from bottom to right depending on portrait or landscape window Using Outlook 1
Rupert Dragwater Background colors not saving in Outlook 365 Using Outlook 15
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 1
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 0
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
e_a_g_l_e_p_i I can't believe what I am seeing when trying to install Outlook 2021 Using Outlook 9

Similar threads

Top