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
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
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 : A program is trying to access e-mail addresses, Allow access for 1 Minutes I want to stop this a
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
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
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
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
I pull the Subject, received date and sender's name with the following code: Set InboxSelect = GetObject("", "Outlook.Application").GetNamespace("MAPI").PickFo
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
In Excel we have the "Name Box" in the upper-left side, but I could not find a way to retrieve the name of a shape in Word. How do I do that?
I've an Access database that records and saves email on the mailitem_send event. Saved email looks like: I want email to appear like an already sent email, li
My users have their personal mailbox as their primary account and an auto-mapped shared mailbox configured in their Outlook 2010 client. The shared mailbox is a
I have a database in SQL Server that I'm using to feed some financial reports in Excel. I'm using Recordsets through a custom Excel Function that uses arguments
I am running an Excel 2010 macro that opens another workbook and removes a few code modules (a form and a BAS module). After that it re-imports them as an updat
I wanted to develop a macro for my worksheet that would pick up a range and change the color of specific chars based on its color. This was similarly answered b
I have an Excel userform I want to resize on opening to fit the screen resolution. I get the height and the width through Application.Height and Application.Wi
I have written a code for web data downloading using selenium VBA, it works good in Firefox, but many time Firefox is crashing. I tried to launch chrome/IE from
I just learned to use VBA in excel, I have a spreadsheet as shown, I have columns from B1:B12 containing content to search and move, I want to build code to se
Set objOutlook = CreateObject("Outlook.Application") Set objMail = objOutlook.CreateItem(0) objMail.To = "[email protected]" objMail.cc = "[email protected]" o