I have been trying to write a macro that updates a presentation through powerpoint vba using tables from excel. Here is what I am doing The code first deletes
Most of my tasks are done via Outlook 2016 ie most of the work I do is composing and responding to emails. If I don't switch Outlook offline, I get distracted f
I'm looking to find and/or develop an automated approach for converting existing PowerPoint presentations across aspect ratios (namely from 4:3 to 16:9 format).
I have a script that pulls the first cell value of a table from a database and adds it 10 times. I want to write that list to excel. Here's what I have so far:
I'm currently writing some code so that when I send an email based upon certain criteria it will save it in a specific folders. I know that rules do something
I have an excel based bank reconciliation that I'm doing a manual matching like the example below using ABS or conditional format, but I need to do a faster mat
I'm currently writing some code so that when I send an email based upon certain criteria it will save it in a specific folders. I know that rules do something
Using Microsoft Outlook, I am trying to change the name of a specific attachment when the user clicks the "Send" button in a new outlook email. If an attachme
In my form access I want to make a button to browse / choose an excel file and import it in format a table in access. This is my code. ' Requires reference to
I have mashed up a VBA script from various web sources to save selected Outlook 2013 mailitems as *.msg files on the filesystem. This works well but I want to a
i have about ten responses from StackOverflow open but none of them quite answer my problem. i have created several UserForms in Excel VBA for this particula
The MailItem.SenderEmailAddress and MailItem.To fields are coming through as null unless I run Outlook at admin. How can I get the sender's email address and t
I have code to track changes in the Category of emails in a Public (Shared) Folder. I have set up the code to be able to switch it "on/off", and this code is in
I have a worksheet that uses randomly generated numbers in calculations to produce results in two adjacent cells (let's say A1 and A2). I am trying to perform
I’m trying to create a series of input boxes that will prompt for more information before executing the rest of the code. I’m stuck on the looping a
Below is my code where I'm trying to export a MS Access query output to an Excel file and then editing the Excel to create a pivot table on a new sheet. The cod
I am trying to apply filter from a master worksheet to multiple worksheets in the same workbook. eg. There are 3 worksheets in the workbook, with following fi
I am trying to export a MS Access query to an Excel file and then create pivot tables in the excel file based on the data dump extracted to the excel file. My i
In Workbook.Open() I have an Application.OnKey for every letter on the keyboard and all the numbers. The letters open a sub LetterPress(L as String) Example for
I'm trying to turn general data written as fractions like 3/4" or 13 7/32" into 3 place decimal numbers such as 0.750 or 13.219. I have a working table replacem
elasticsearch-1.0.0