I have an excel spreadsheet that has drop down comboboxes on sheet 1. I am trying to find out how to autofill the 5 boxes to the left of the combobox with conte
I am trying to select a worksheet every time when i open up a workbook using an inputbox in VBA. here is my code for opening a workbook but after i open up my w
I need to place a userform next to a selected cell. Here's my code. Excel 2013. In the userform module: Private rangePosition As Range 'Property passed to for
I have created Excel addin project using Visual Studio to insert a data into database. The problem is I'm unable to open a File upload box in this. I am getting
Good morning, I need to set cells background colors using PHPExcel, but I don't know how to do it. This is for my header and It's working: $styleArray = arr
I have a VBA project where I need to create a userform on which there should be an attachment button to select multiple images and save them in a folder with a
I want to look through my Excel worksheets and find a sheet with a certain name and delete that sheet if it is found. Afterwards I want to create a sheet after
I have an array of 30 columns and 800 rows (Sheet 1), each cell has either text or is blank. I want to check if ANY values in this array (specificially row by r
The goal is to iterate through rows of the character table and replace each character with it's substitute. The character table in this example is ={"&","&a
I need help in converting a .xls file to .xlsx using C# and without using Microsoft Office.
Hello I am just trying to get into a bit of macro programing to help my Mom, and Dad get some excel work done, and they have some ungodly amount of paper work i
I am still relatively new to Java and have cobbled together enough code that allows me to write my data out to a new excel file. However, I want it to write (a
I am wanting to write a C# program to copy a specific range of cells below a specific keyword. The code will identify a keyword in Excel and then copy the value
I'm working on a rec process which will pull data out of a SQL Server database into Excel and out of another application to compare the two sources. I've writt
So I have an Excel document, which is essentially a table. For the purposes of this, we will use this: Dummy Data What I'm wanting to do is take the values fr
I have a large xlsx Excel file (56mb, 550k rows) from which I tried to read the first 10 rows. I tried using xlrd, openpyxl, and pyexcel-xlsx, but they always t
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update
I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da