I have to pass data from Access database to a MySQL database attached to HeidiSQL automatically every minutes. To do that i put the data into excel files format
I have a function that aims to return the visible cells (as a range) after applying an autofilter to an inactive worksheet; the autofilter data is represented b
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a form that is selecting emails based on companies that have expired insurances. Some companies have both a Business and personal emails whilst others ha
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
I generate an email in vba and send it. I have a class which includes the send event for that email so I am able to tell if the email has been sent. My issue is
Is there a way to tell if some dynamic array, for example arr() as String is initialized? IsEmpty and IsNothing seems not to work with dynamic arrays. Currently
I set up a custom domain for my Microsoft 365 business account ("@company.com" is the custom domain which is really "@company.onmicrosoft.com"). I have two othe
I know this is a topic that is talks about a lot, but I just cant find the answer. I have a range. if in that range there is a word then I need it to go to the
I'm trying to pull a set of five emails from a specified Outlook folder based on two conditions - the (partial) subject line, and received between two specified
I wrote vba script to duplication my main calendar to another calendar, including recurring meeting. All is well except when the organizer do out-of-order modif
My workbook consists of 2 sheets: Sheet1 is the primary dashboard that the user sees, while Sheet2 consists of a pivot table and regular table. I'd like to imp
I have the below code for one of my financial reports and I'm struggling with updating the code to make it more automated. The code creates a string of the colu
I am trying to run a python function called comments() from vba and getting an error with the following code due to spaces in the file name: Sub notes() Dim f
Code: Dim Application As Object, namespace As Object Set Application = CreateObject("Outlook.Application") Set namespace = Application.GetNamespace
I'm using Outlook 2016 and I have two PST files listed below my default Exchange mailbox/store. In the Folder Pane, I can click and drag the PST mailbox/store a
Using excel macro The first line is the json file name, and the second and subsequent columns are the values. With the first column as the key to the json obj
So i've been trying to wrap my head around this for weeks now and have tried many things but nothing that works for my case, I have two sheets with "similar" St
I am trying to test a cell for specific data. If it contains that data, I do not want my code to run (because that would leave my worksheet and workbook Unprote