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 1
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
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 3
D Alerts in outlook Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 3
L Recommendations for Utility to Backup Outlook 365 Account Settings Using Outlook 0
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
T How to configure Outlook for two users on a single Windows account Using Outlook 3
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
B Outlook 213 keeps crashing. I just found out there are DMP files. How can I tell Why? Using Outlook 2
H Outlook 2016 related mails in outlook Outlook VBA and Custom Forms 13
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1
@ Outlook Using Outlook 2
kburrows Outlook 365 - Ribbon Customizations Disappear Using Outlook 0
D Wishlist How to use 'app password' in Outlook 2003 after Google pulled plug on "less secure apps" Using Outlook 2
L Restoring Outlook from backup pst file Using Outlook 5
e_a_g_l_e_p_i Kernel Outlook .pst viewer Using Outlook 3
L Outlook 365 Outlook not working on linux how to solve it Using Outlook.com accounts in Outlook 0
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
S Activities in Outlook Outlook VBA and Custom Forms 3
S ios outlook Using Outlook.com accounts in Outlook 0
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Outlook - eliminate same adresses from to, and bc line Outlook VBA and Custom Forms 0
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
G Outlook Express (DBX) to Outlook (PST) Conversion Software Wanted Using Outlook 1
J Outlook 2016 Can't display some embedded HTML images in Outlook 2016 Using Outlook 2
N Outlook 2021 'Run Script" Rules? Outlook VBA and Custom Forms 4
C Why does Outlook (desktop) 365 for Windows keep making me input my passwords? Using Outlook 8
P Comcast IMAP broken but their second level support said to call "the Outlook company" Using Outlook 4
bdsermons Outlook 365 command button in outlook form Outlook VBA and Custom Forms 5
B iCloud telling me my Outlook is not supported Using Outlook 2
T Outlook 2021 Cannot open attachments Outlook DeskTop 2021 Using Outlook 0

Similar threads

Top