Search results
1 sie 2014 · I have found though that deleting a worksheet (one that used to be xlVeryHidden) with conformation message box enabled causes the save as dialog box to appear every time. If I force the conformation prompt not to appear (application.displayalerts = false) then the save as dialog box does not appear!
27 lut 2011 · Dim bFileSaveAs As Boolean. bFileSaveAs = Application.Dialogs(xlDialogSaveAs).Show. If Not bFileSaveAs Then MsgBox "User cancelled", vbCritical. Nice one cheers brettdj and repairman615 very helpful advice! This code works great for what I'm trying to do. Can you help me take it one step further.
29 lut 2024 · After using the saveas statement, the image is not present in the file previously saved. When the email is in display mode, if I do a saveas manually of the same email into a file, we don't see neither the image inside.
8 paź 2021 · Right out of the gate, the Outlook Application doesn't support VBA FileDialog object. Theoretically Outlook itself supports this since you can do File > Save As and File > Open & Export...but you can't simply call the object from VBA.
18 mar 2024 · After using the saveas statement, the image is not present in the file previously saved. When the email is in display mode, if I do a saveas manually of the same email into a file, we don't see neither the image inside.
27 lip 2016 · I am trying to merge Macro 1 & Macro 2, so that the user may use the "Save As" dialogue box to save the output file instead of having to manually enter the address in. I am using Office 2010. Macro 1. Exports tasks from Outlook into excel: MsgBox "The filename is blank. Export aborted.", vbInformation + vbOKOnly, SCRIPT_NAME.
29 sie 2013 · Is there a way to use VBA to open the save as dialog box, set a default name from cell information, and pick the save as file type?
