Category "vba"

Weird characters in email body

I have a little problem with VBScript. There is how it should work. It is a simply code that should go through all emails in particular folder, get particular e

MS Outlook 2016 - Macro VBA search by conversation not all flagged as done

Is there a way to create a search folder in Outlook, that returns only conversations where not all emails in the thread/conversation have been flagged as comple

.SentOnBehalfOf and .SendUsingAccount on forward

I go into a shared inbox and forward an email as myself, to my boss, using HTML formatting. I wrote VBA code that works on every step except changing the From l

Find all email addresses corresponding to an ambiguous name

User has a column with names (or name, surname) to send email. When there are several with the same name and surname the macro is selecting the first matching.

Dynamically setting of cells' NumberFormat in VBA excel when the uncertainty calculation in consideration [closed]

I need dynamically set via VBA NumberFormat to imported txt file values, as just below : Imported values number type is "General" so I want to

If two range criteria are met, copy a third cell and paste it to another sheet

I have a sheet called "Scores" where I have Column D and J with values from 1-9 in both columns. In this same sheet I have a Column A with the corresponding nam

How to reference a Subfolder of Archive?

I'm using Outlook 365 - Microsoft Exchange(owa). I have written a script that looks for emails in my Outlook Inbox with any subject line containing "PHI Attriti

Issue regarding deleting paragraphs

I refer to a code from :https://www.datanumen.com/blogs/quickly-find-delete-paragraphs-containing-specific-texts-word-document/ However, I can only delete the h

Deleting mails from shared mailbox, one at a time, is very slow

I have a macro in Excel to delete mails older than 30 days from folders and subfolders in a shared mailbox. I have a sub for looping through each subfolder and

How to call a php file with arguments from VBA for Mac? Equivalent of VBA.createObject("wscript.shell") on Mac?

Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res

How do I format cells to have the match function work for all numbers in this data set?

Can anyone explain what is happening here? I have some values in column A that I want to use with the match function. But there are some numeric values that don

Outlook event: On change 'From Address'

Does any one know if it is possible to hook into the event when a user changes the 'From' address drop-down in Outlook 2016: I've gotten as far as testing ou

Delete every second worksheet starting with the first (so 1, 3, 5...)

I am currently using a VBA code from Kutools that lets me combine all my worksheets into one combined "Master" sheet. However, every relevant worksheet is prece

User login form for excel vba

I am trying to create a login form where the username and password input match the data on a sheet. I tried to code for if either the username or password is wr

Pulling data from pdf to Excel using VBA

I have a more than 1000 pdf files and I want to extract/pull data from pdf. If I use the pdf to excel conversion then it will take long time so I am trying pull

Excel VBA Filepath Checker

I'm trying to write a VBA to check if particular files exists in folders. For example in my code, there are 3 files that belong to folder 1, and 1 file belong t

Why does the use of "Debug.Print" lead to "Overflow" error?

I create a function to sum all the cells within a range as following Function SumTest(rg As Range) As Double Debug.Print "SumTest..." Dim s As Double s

Setting Excel cell value based on another cell value using VBA

I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the same row using an equation I have. if there is

How to Paste string of values in single cell of Excel using VBA

I have 2 sheets named "Target Data" and "Pivot". I have filtered data in "Target Data" and now want to copy only visible cells in single cell of "Pivot" sheet.

Word VBA: How to create cross reference to figure in text box?

I'm creating a Word VBA macro to insert a text frame containing an image and its caption, and then create a cross reference to it in the main document text. B