Category "vba"

Creating an Array from a Range in VBA

I'm having a seemingly basic problem but can't find any resources addressing it. Simply put, I just want to load the contents of a Range of cells (all one colu

Opening a file throws error: "Cannot find project or library"

I have an Excel file that uses VBA to calculate active ranges for a few sheets to make a .csv file to be picked up by a reporting server. Every once in a while,

How to Give 'PickFolder' dialogue a title

I'm writing some code in which the user will need to pick both a source folder and destination folder using: Set SourceFolder = GetObject("", "Outlook.Applicat

Send by mail Excel sheet image

I have an Excel with an embedded image. How can I send it by mail using the name of the image? I do not want to send it attached, I want to embed it in the htm

How do I change the 'From' value of mail failure items?

I'm exporting/extracting mail failure items located in a subfolder named 'Subfolder' to a local folder on my laptop using this Outlook code: Private Sub DBC1()

How can a run a script rule be reset after it stops working?

I cobbled together a script and rule to save incoming emails as .txt files on our server. It works for about a day or two, but then stops working until I delete

How do you use " (double quotes) in a formula in OpenOffice VBA? For instance with Replace()

I am looking to replace double quotes, ", with backslash escaped double quotes - \". I read online that you can use double quotes in VBA, if you use two double

Include Microsoft team meetings while setting meeting in outlook

Does anyone know how to include Team Meetings while setting meeting in Outlook using the VBA code below? Below is my code: Sub setmeeting() Dim O As Ou

VBA-Json Parse Nested Json

Thank you to @QHarr for working on this with me! My goal is to grab the values for each of the nested categories from "orders" my json: { "total": 14, "

Insert Signature in Outlook Email

I found this code, but it doesn't include the signature. In all the resources I've read, I couldn't come up with a solution. Public Function Email_Test() Dim

How to include signature on email?

I have a code that sends an email too individuals on a list. I need the user's signature to appear at the bottom of the email. I cannot get it to display. B

How to set alias as the From account?

I have VBA code in Excel that sends an email via Outlook 365. My primary email account (@outlook.com) has five aliases. These are not separate email accounts b

how to get real formula from EXCEL formula

| A | B ------|-----|-------- 1 | x | 1 2 | y | 2 3 | z | 3 4 | a | =B1*B2+B3 Imagine the above stuff is part of an ex

Macro send email, change 'from' Display Name but NOT email address

I have this: .SentOnBehalfOfName = """Customer Service"" <[email protected]>" the name "Customer Service" is officially associated with the

disable editing in cells without protecting worksheet vba

I want to disable cell editing (direct typing into cell) but want to update that cell through code without protecting worksheet Does anyone have any idea?

Replace text using RegEx in Excel-VBA

I have data in Excel like follows (one row here - one cell in Excel): 07 July 2015 12:02 – 14 July 2015 17:02 12 August 2015 22:02 – 01 September 2

Cannot run the macro. "The macro may not be available or all macros may be disabled"

This topic has been already mentioned, however without a solution. I have a very simple Macro calling other workbooks and their macros to execute: Sub Execute(

The loop over two arrays take LONG

Thanks for your helps, I have two arrays: A (100k row, 10 col) and B (100k row, 12 col) The following code (thanks to BSALV) loop through A and B => It takes

Run CATIA VBA macro in batch mode from Visual Studio

I have created a VB class to manipulate a CATIA project. The VB code is compiled into a dll loaded into a C# project. Imports ProductStructureTypeLib Imports I

Run CATIA VBA macro in batch mode from Visual Studio

I have created a VB class to manipulate a CATIA project. The VB code is compiled into a dll loaded into a C# project. Imports ProductStructureTypeLib Imports I