Category "excel"

How to Add Default List from Dropdown using Excel VBA then Do something when a Submit button is clicked

How do I put default values on my dropdown? I tried view code but I'm not sure how to or what codes should I put in there. I tried DropDown7.List = Array("Link

Office protocol handler works with Office 2019, but not with Office 2016

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

Excel: Force recalculate on save

I have a simple macro that returns the date of the last save of the current document: Function LastSavedTimeStamp() As Date LastSavedTimeStamp = INT(ActiveWor

Use Wildcards in Replace Function in combination with 2D Array Values

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

How to find and replace the column name?

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

How to copy and paste data, in lots of 200, from horizontal to vertical?

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

Populate date based on combobox selection

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

Sharepoint Locking Error when xlsm is Uploaded via VBA .SaveAs

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

Get Dropdown item value while reading Excel file - C#

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

How to find the sum given n, 1st score and last score?

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

Adding a second line to a graph in excel via c#

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

Assign a value to a "hidden" input webelement, in SeleniumBasic for Chrome

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

Shell using path pulled from cell in workbook using VBA

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

Compare two excel files for the difference using pandas with multiple tabs

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

JAVA - Compare value in Excel file with files present in the folder

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

How do I pass a cell value, for the Subject line, to code called to create mail?

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

How do I hide a range of rows by getting the start and end row values from user input cells?

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

Excel Office Scripts - Copy and paste range if filtered data is not empty

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

Call COM Add-In Function in VBA

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

Populating range from array

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