Category "vba"

VBA Calling WSDL simple method with 1 parameter XMLHTTP

I need some help Calling a wsdl web service function. The WSDL have one function named "Bye" that is waiting for 1 parameter of a type String. Then it gives bac

Can I get data from power query to a vba variable?

I have a power query function, e.g. getData with one parameter filename Can I invoke that function directly in a vba variable? Something like: Sub MyTest() D

vba vlookup does not work in loop

I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da

Outlook VBA Access Folders in Shared Mailbox

I have some VBA code in Outlook which behaves perfectly for the main Mailbox - however the same code is struggling when I add a secondary mailbox - this is Outl

Forward Outlook email without adding signature nor From: and To: of original email

I'm looking to forward email that I receive in Outlook to a new address with no changes - an exact clone, no envelope information nor signature added. The emai

Run macro automatically when cell value changed (not changed by user)

Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th

Prompt user to select multiple files and perform the same action on all files

The user has hundreds of text files and requires making a change in the data before saving and closing them. Below is the code I have for a single file; how can

Userform - Redirect focus on textbox after MsgBox

I hope this is not that stupid, but I really did not find a post that was working for me. Situation: I want someone to put a date into a textbox in a Userform.E

BSTR's and VARIANT's under... mac os x

Under mac os x I have office 2011 and its excel and VBA, and I have gcc-5.3.0's g++. I played a lot to passing arrays (of numerical built-in types) from VBA to

excel/vba: count number of unique male and female students in list

I have a database of students with names and their gender, however the list contains repeats of students on different dates. How do I count the number of uniqu

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

Why is Boolean's size in vba 2 Bytes?

In my apprenticeship we started doing now vba at school. When our teacher handed us out the data type summary, I was kind of confused. ..... Boolean -> 2

How to stop OutLook Security Message programatically : A program is trying to access e-mail addresses, Allow access for 1 Minutes [duplicate]

How to stop OutLook Security Message : A program is trying to access e-mail addresses, Allow access for 1 Minutes I want to stop this a

Excel 2016: Error accessing file. Network connection may have been lost

we are developing an Excel 2016 Workbook using VBA. I descrivbe the error from my side, but it occurs at several independent Computers - even at the customer's

Rename PDF based on its content

How do I specifically extract the name from a PDF (screenshot as shown below) and rename the PDF as the name? So in this case, I want to extract Daniel Thomas f

Run-time error '1004' Insert method of Range class failed while adding column

It seems pretty easy, but not able to find workaround. Excel 2010. Aim: adding 22 empty columns starting from B Error: Run-time error '1004': Insert method o

Controlling Program Flow Between VB and C++

I have a program that runs from VB/Excel and executes a C++ program in the middle of it. I have two (I think related) questions: I capture the return value fr

Get sender's SMTP email address with Excel VBA

I pull the Subject, received date and sender's name with the following code: Set InboxSelect = GetObject("", "Outlook.Application").GetNamespace("MAPI").PickFo

Find and replace not working with trackchanges

I´m trying to find and replace multiple sentences from different word files from an specific folder. The words that I´m trying to change are on two