Category "vba"

Excel VBA: Loop and finding multiple values in a range then copying the offset cells in the same range in a categorized list in another worksheet

I am in need of help with looping through a range (In this case Column "C") and finding 5 specific words (Sort, Set, Shine, Standardize, and Sustain) and then o

Office Word vba: How to have different alignments in a word table cell?

I want to write in a word some information via vba. I'm having a problem with the contents of a table I want to import. As you can see my table has 2 columns. T

Search for value in a Range, if found, variable = 1

I'm trying to simplify a project where, actually, the user specify their own values in two fields (string1 and string2). Then, in another sheet, there is a form

VBA: Remove objects from object collection

I want an Access application to autimatically import the right files from a certain folder. My idea to do this, is to get all files in the folder and then proce

Outlook ReportItem.Body returning messed up encoding

If certain users automate the Outlook Client to view bounce backs/ReportItems in a shared inbox, rather than returning the clear text of the message as indicate

Create folder path if does not exist (saving from VBA)

I have a list of items in a sheet like so: My code goes through each row and groups the supplier and copies some information into a work book for each supplier

Outlook attachment names in DASL

I am trying to get a list of attachments in the Outlook table. I have tried below code. It throws an error. Any help is much appreciated as I am new to DASL q

Automating Mail Merge using Excel VBA

I created a macro in Excel where I can mail-merge data from Excel into Word Letter Template and save the individual files in the folder. I have Employee data i

VBA editing cells in protected sheet

I have protected a workbook using vba code. I would also like to let the user entering some values in the specific cells (n4, p7:p10). I have tried by using t

How to search recipients of previously sent mail?

I have a code which checks the subject in my e-mail and warns me if I already sent an email with this subject. I experienced it would be smarter if it checks fo

MSAccess 2010 VBA Open a read-only database

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

MSAccess 2010 VBA Open a read-only database

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

How to Left-Align HTML Table, created from an Excel Range, in an Outlook Body?

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

Excel Function to find a combination of numbers

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

How do I work out how many of each value in a column I would need to add up to a total value in excel?

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

Why is a line added to .Body when creating mail?

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

Extract the values in a drop-down field

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

Suppress dialog box for a dropped shape in Visio VBA

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

How can I write this Macro into few lines. I want to get rid of this multiple lines

Sub Flow_Drop() If ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 1").Value = xlOn And ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 5").Va

Print original email when it is undelivered

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