Category "vba"

VBA Issue Excel

i am trying to add a translator in Excel, but i can't figure out where the mistake is in my Code: I am trying to add a translator in Excel via VBA. The problem

How to copy rows x times based on cell values into another sheet, & create a new column filled with specific content?

I'm very new to VBA and I'm struggling with something I can't manage to succeed. I have several columns, some of which work in pairs : the first element of

Sending Email with attachment by MS-Outlook in VBA, Excel when Outlook is closed

When I send mail free from attachment, works truly. But when I using the .Attachments.Add ActiveWorkbook.FullName parameter, it does not send and been pending

Getting Outlook Redemption to work on 64-bit operating systems?

Our servers are upgrading to Windows 10 64-bit (which is also using Office 64-bit products) and I noticed that in this environment, the old Outlook Redemption c

How to access EmbeddedItem attachment in Outlook VBA

I am using Outlook 2010 and the QuickSteps only allow to create a Task from an email with the email body copied to the task body or with the email as attachment

Why can't I `End` code while I'm subclassing without breaking everything?

Context I've written some code in VBA to subclass a userform so that ultimately I can intercept WM_TIMER messages being dispatched to it. I'm doing this instead

Getting specific cell data from SAP to excel

I am trying to get data from specific cells in a row in SAP, into an excel table using VBA. When I record a macro of me clicking the 5-6 items I need, it only g

Clear filter from Table

I'm trying to run a macro that replaces data in a table in Excel, when the data might initially be filtered. The code should remove the filter first, then run

How to get Microsoft Exchange email addresses other than the primary SMTP address using VBA

I'm attempting to pull contact information from an Outlook.ExchangeUser object using VBA in Excel. However, so far I've only been able to get the primary SMTP a

Excel UDF to Unpivot (Melt, Reverse pivot, Flatten, Normalize) blocks of data within Tables

This question will seek multiple approaches LET/LAMBDA VBA UDF and Power Query Function, so there will be no single right answer, but a solicitation of approach

Setting the location of a form in access vba

I'm working on an Access application with multiple nested forms on which the users clicks on selections in order to do specific tasks, e.g., enter new data, sea

create a repeatable pivot table that loads on the same worksheet

I try to take a table and create a pivot table adjacent to it. This macro needs to work on separate worksheets so the table and pivot table names need to be ge

boolean array and variant type vba

I am getting unexpected results when passing a boolean() array to a variant type (the variant type resides inside a class module). I expect to get a value of tr

Target.Range.Offset - or something like that

I'm trying to accomplish that if you click on a hyperlink (in column P), it would copy the cell in the same row but in column B to another cell (A3). I'vre trie

Best way to change the "From" address on an arriving email in Outlook's VBA script?

My overall goal is to change the "From" sender on an incoming email to something else. Specifically, I get chat logs from Zopim chat and they're all coming fro

What is the VBA property for: Server folder contains x items?

I like to compare the amount of items in each folder on the Exchange server with the amount of items in my local Outlook file. In Outlook I can use the followi

How to sum and Copy paste in sheet 2 row incrementally

I am new to Excel VBA. With reference from a search engine I have created the above code but stuck at one point. My requirement is to sum data in the range of s

How to convert Outlook messages to text maintaining double-byte character set?

I have a code to convert outlook emails into text. Works great except for emails received with DBCS (double-byte character set) from CJK (Chinese/Japanese/Korea

Automation error in global address list lookup

I'm trying to look up a person's email address using the Outlook global address list. Here is the VBA code I use to do it. 'Snip If firstName <>

How to refresh ActiveInspector?

I changed the sender data in the currently open mail. This is well done by the following code: Sub AktiveMailSetVonHotline() Dim oMail As Outlook.MailItem