Way to run Excel macros from command line or batch file??

I have an Excel VBA macro which I need to run when accessing the file from a batch file, but not every time I open i...

How to fix Error Code 424, Object Required?

I have an ActiveX Listbox and Combobox which I'm attempting to get the combobox list dynamically populated dependent...

Vba code: Filling the blank cells with zero dynamically?

I need to fill my blank cells in a worksheet with zero. Currently I was doing it for C12:H35. Can someone please tel...

How can I convert a range to a string (VBA)??

What is the best way to convert a range of cells to a string? I have a function that only takes a string as input so...

Excel VBA Sending emails with multiple attachements?

So we are holding this big event and I have an excel sheet with everyones name, email address as well as their itine...

Combobox null in if statement?

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it h...

SendInput VB Basic Example?

I hope someone can assist, I trying to find an example of a SendInput code that simulate keyboard commands, I wish t...

Find the Window handle for a Chrome Browser?

I have found some code to bring the browser to the front, even if it was minimized. I don't however know how to get ...

ms access - vba: Compile Error: expected: =?

I have a subroutine as below Public Sub updateStagesTable(sName As String, percentageValue As Double) stageName...

Replace cells containing zero with blank?

I have a very large amount of data A4:EW8000+ that I want to replace cells containing a zero with a blank cell. Form...

VBA Excel Run-time error Automation error?

I had a Run-time error '-2147418105 (800100007)': Automation error The object invoked has disconnected from its cl...

Loop without Do error?

I'm trying to implement a simple Newton's method iterative solver using Excel VB (I have never used VB.) I keep g...

VBA Macro: Error 13 Type Mismatch, error 2023 on cell?

I am trying to make a macro that groups up rows and sums the amount of items that they have on a column, I made it s...

VBA Excel “Compile error: Object Required”?

I am working on VBA code in excel and i have the following piece of code Set strModel = Right(rng.Offset(0, 13).Val...

How to use indirect reference to select a single cell or range in vba?

I need simply a code for selecting a cell, however that cell to select changes. I have a cell in the workbook that w...