I have a MSAccess database that I'm trying to pull archived data into, from other MSAccess databases that live in read-only folders. So ... Dim aidbx As DAO.Da
I have a MSAccess database that I'm trying to pull archived data into, from other MSAccess databases that live in read-only folders. So ... Dim aidbx As DAO.Da
I want to copy a selected range from Excel to the body of an Outlook mail (Office 2013). The table is pasting with Center Align. I want to paste with left-align
I have a number on a spreadsheet which is a combination of many different numbers on a list. For example: A list contains: 100, 200, 250, 500, and 1000 The numb
So say A1 - A8 contain values 11, 120, 321, 435, 623, 765, 964, 1039, B1 Contains a value of 1375 how could use a formula or macro in excel to work out how many
I use an Outlook rule to run a batch file in Windows that takes as input the Subject and the Body of the email (this means two arguments). If I run the line dir
I would like to extract the values in a drop-down field with the title "email address". I would like the name selected to appear in the email "To" line. I'm add
When I drop a milestone from the shape master onto a page, a dialog pops up asking for data (milestone date, description, etc.). How can I prevent this dialog b
Sub Flow_Drop() If ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 1").Value = xlOn And ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 5").Va
I'm using MS Office 2016 Desktop App on Windows 10. I didn't find any success searching online and also contacting MS Outlook Support to find that there is no e
I have different accounts in my Outlook. Depending on the currently selected folder, I would like to find the smtp Email address of the corresponding account. (
I have 3 combo-boxes and an OK button. I need to set the value of multiple cells in multiple worksheets equal to the value of the combo box selection. Dim choic
I am trying to file emails using a macro, but I am having issues if the user selects a conversation header. What is the typeOf of these headers? I am trying
I am using a button from an unbound nav form to open a different form. The button Macro closes the nav form and opens the form I want with no issues. I have a q
Scenario I have an excel cell that contains value with leading zereos (Eg: 0002). My macro is copying this value to a variable called runNumber and pasting it i
I am trying to process some rows in a sheet with VBA. I want to cut and paste a set of rows from one sheet to the other and struggling to work out the code I ne
I'm trying to use a vba if statement to check if my cell H22 on sheet 1 matches a cell in column I on sheet 2. can someone please show me where im going wrong?
I'm trying to teach myself VBA during the short holiday break. For my first module, I want to create a module that does the following: Displays dialog box. Pro
Is there any way to automate Edge in IE mode using VBA without Selenium drivers. Will it work in same way as how it works in IE. We need to use the same code in
PowerPoint 2016 has a neat new feature where you can insert Zoom Slides/Sections. See here if you don't know what I'm talking about: https://support.office.com/