On an Intranet web page, I have a link to an Excel document that resides on a network drive, like so: ms-excel:ofv|u|file:///N:/folder/file.xlsx This is an off
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 reading an Excel spreadsheet using the microsoft.office.interop.excel library in C#. I need to first determine that a cell in the sheet contains a Dropdown
Lets say you have a column called "values" and "no.of times". You have thousands of rows but you don't want to scrape the data from the site.. You have to calcu
I want to create a simple line on a graph in excel that I have generated with code. I add the data to an excel sheet and can generate a single graph of that dat
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 found this nice script online which does a great job comparing the differences between 2 excel sheets but there's an issue - it doesn't work if the excel file
I have an excel file that I read through org.apache.poi, but I would like to read all the values of column 1 and column 2. If the value in column
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
Summary: I have a multi-step script where I need an IF statement to handle a scenario when the range I am copying from could be empty. I need the script to move
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