I have a simple macro that returns the date of the last save of the current document: Function LastSavedTimeStamp() As Date LastSavedTimeStamp = INT(ActiveWor
I'm trying to go through a list with two columns and replace some of the text in the second column. I want to search for values using wildcards in combination w
I am trying to find and replace the column name. I want to loop in the first row only but my code loops the entire sheet. Dim sht As Worksheet Dim fndList As V
I am trying to copy and paste data from horizontal to vertical from sheet1 to sheet3 in a lots of 200. Say I have a list of 600 tickers. The code will copy the
I have two items in ComboBox1, one is Cardio Only and second is Gym Only. I want to auto populate Renew Date in TextBox8 based on Combobox1 selection. e.g. If I
I have this awesome vba macro that takes a template xlsm file saved on a shared drive and automatically uploads the file saved as with tomorrows date in the tit
I'm trying to send data from excel spreadsheet to sql server. The code runs properly but the change of status is not done. Before those steps, I already added d
I have to migrate a web automation program from IE controlled by Excel VBA to Chrome using selenium basic in Excel VBA. The website itself is not public so I ca
My code runs a model in R directly from Excel. I want to simplify installation so instead of: path = """C:\Program Files\R\R-4.1.1\bin\Rscript.exe"" C:\Users\di
I have an AutoHotkey script that inserts values into various bookmarks in a Word document. When inserting a hyperlink (email address), it inserts text. How do I
I am gluing pieces together to automate sending emails with each new line added to an Excel sheet. I want the subject line to contain the text of a cell in colu
I have a sheet of 1,000 plus rows. I'm trying to hide all rows that match the values I input into cells A1 (the starting row in the range), and cell A2 (the end
I cannot get it to work in VBA - Excel. I use the same header and XML-body in Postman - fine! Good response. I need to use a client certificate to identify myse
I want to call the "Refresh" function of the Microsoft Dynamics NAV Excel Add-in which has a button on the ribbon using VBA. I tried recording a macro when clic
I have a worksheet change event that runs when three adjacent cells in columns C, D and E are filled with any value, which puts the date of entry into a separat
Normally when using the VBA editor, code autosuggests from available methods.properties for whatever object being referenced. I'm trying to pull data from an Ex
I've seen this error message on other posts but none matched my situation. I have a few AutoFilter functions done one after the other checking if the target cel
I have some VBA that works as follows. For messages that are selected in Outlook, it marks them as read, assigns a category and moves them to a subfolder. It
I am trying to create a macro that inserts an image into one cell when the user enters specific information into an other cell. Right now it's working but not r
I am trying to create a macro that inserts an image into one cell when the user enters specific information into an other cell. Right now it's working but not r