I am trying to do a email export from outlook to excel macro which includes the recipient, email subject and most importantly the date time of email reply. I ha
How to properly save this kind of attachment (from signed message)? I saved this with .SaveAsFile method, but it is without any extension and no application can
Yet another topic with multidimensional array and Redim Preserve, I know. I read a lot of them but still can not understand why my code is not working. I kwow
When I use (some code here).copy destination:=(some code there). It will still prompt for protection issues on cells. Basically it just won't let my code runs.
I need help with this macro. Every time I run it, I get the error below. I thought it was a simple macro that I could have anybody on my team use to make it t
My problem is that an Excel spreadsheet (exported from Access as .xls) has cells that look empty, but are not. This is mucking up my calculations & navigati
I tried the following to filter (between filter) my worksheet based on 2 values. The 2 values are input in textbx1 and textbox2 in userform 'A1_Filter_Range'.
I have a lot of PDFs to convert to excel. I found the code below which converts PDF to excel by opening the pdf file in word but it fails at Dim fso As New File
I have been using this code in office 2013: With OutMail .Attachments.Add fName .HTMLBody = .HTMLBody & "<br><B>" &
This is specific to Office 2013. In previous versions of Office (2010), I had a script which would download an .ics attachment and then save it to my calendar.
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