I'm wanting to automate a few things in Excel, problem is I am definitely not a programmer / scripter so this is all foreign to me. I have a list that changes i
I would like to change the response to a meeting, that I have accepted, to tentative and send text like "I'm sorry, but I cannot attend.". Online, I found solut
Dim path as String dim a as string dim b as string a = range("A4") // variable name in cell b = range("A106") // variable of other name in cell Workbooks.Open
I have a procedure called TableNumberSequence that adds a table row, pauses for a second and then adds another. It does this up until what's specified in the co
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