Category "vba"

Is there any way to get the date time on the "you replied to this message on [xxx]"?

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

Saving "Device Independent Bitmap" attachment

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

Issue with Redim Preserve (2D array)

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

EXCEL VBA UserInterfaceOnly:= True not working

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.

Run Time Error 5 - Invalid Procedure Call or Argument

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

Excel cells from Access export look empty but are not (=isblank=FALSE)

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

Excel VBA: Autofilter using textbox values

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'.

How to convert PDF to Excel on a Mac?

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

add attachment picture into html email body in office 16 / O365

I have been using this code in office 2013: With OutMail .Attachments.Add fName .HTMLBody = .HTMLBody & "<br><B>" &

Open.ics with Outlook 2013 to read items

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.

Powerpoint vba - copying table from excel

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

Automating Outlook offline / online

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

Automating conversion from 4:3 to 16:9 in PowerPoint, including contents

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).

Writing To A Range Using VBA array

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:

Outlook VBA how to improve speed when looking thru a folders list

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

VBA Create a macro to match items in a bank reconciliation - payment booking/ Bank debit

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

Outlook VBA how to improve speed when looking thru a folders list

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

Use VBA to Change the Name of Specific Attachment when the Send Button it Hit

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

MS Access Form button that allows user to browse/choose file excel , then imports file to a table

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

Manipulating the item details of an outlook msg file in Windows Explorer using VBA

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