This is what I want to achieve with the code further down: If I use the RETURN key, the cell right next to the current cell should be selected, rather than the
I am trying to find a specific subject in a shared outlook calendar on a specific date. The subject, the date and the shared calendar is passed as arguments. Th
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 '''