long time user of the forum but first time I'm actually asking something so please let me know if I'm doing something wrong. So I'm writing a Powerpoint Macro t
I have an ODBC connection to a database set up in Control Panel using a DSN. I can use this to see data from tables and Views in Excel. What I need to be able t
I stole the format from an answer to a similar question : Insert Image into Word by using VBA The problem I am getting is that it keeps not actually setting the
I want to delete all the rows containing the word "Resigned" only in column O. This is my code below to process 331,000+ rows. Is it the most effective or fast
I'm trying to get the result of a Count query into a variable so I can use it (basically I just need to know if it's greater than 0). My code looks like this:
I have a few spreadsheets with various tables in different formats. My task is to locate and identify anything on the spreadsheets that can be considered a tabl
I am currently struggling with coding and need help from an expert. Help. There are a large number of classes ("df-table") on that link homepage. The first clas
Good morning, I have this code below that send an email with an attachement (excel file) and a table in email's body. Sub Email() Dim outapplication As Object
Input: Sub RangeFindWithDoubleType() Dim strResult As range With ActiveSheet.range("A2:A11") On Error Resume Next Set str
I am relatively new to VBA and have managed to edit a worksheet_change sub from example code found online (Thanks Tim Williams!) that allows multiple selection
I've set up a macro to send an e-mail through Outlook. .Body is read from a cell inside the file with indents. Since the value will change depending on the usag
In Microsoft Excel VBA I need to create a class that has two properties, "Name" and "Holdings". "Name" is just a string so the code for that is easy. But I ne
I get 50 mails with Excel sheets per day. I want to add the first line of each Excel sheet to an existing Excel sheet located on my computer. I first wrote a sc
I have written code in VBA which copies a dynamic table (dynamic because it could be 20 rows or 200 etc) from one worksheet into another. The issue I am having
I have found code to search a table and load cell values into the form. I need to be able to make changes and save the form data back to the table to update th
sFile = Dir(sPath & sFile) Debug.Print sFile 2022.txt is returned if sFile (the active cell) contains 2022.txt; how can I return the same if sFile contains
I am using the Update query inside VBA to Update one particular column. But I am getting the Data Mismatch in criteria expression error. Please find below the c
I am trying to compile my code but every time I get the same error: Syntax error (missing operator ) in query expression ' True Status.Subsystem Not LIKE '''
I am trying to create a timer that when reaching zero, it calls from the "Database" script, and then repeats the timer again from 30 seconds. Problem is, every
I have data on sheet A and want to duplicate it on sheet B. Because it is a lot of data, I do not want to use copy-paste. If I really simplify it, this is my co