I have a script that pulls the first cell value of a table from a database and adds it 10 times. I want to write that list to excel. Here's what I have so far:
I have a column for age and a column for gender. How can I get the number of people with ages between 0-18 and with a gender of "male"? For example, with the fo
I have an excel based bank reconciliation that I'm doing a manual matching like the example below using ABS or conditional format, but I need to do a faster mat
i have about ten responses from StackOverflow open but none of them quite answer my problem. i have created several UserForms in Excel VBA for this particula
I am trying to upload multiple Excels files (same format) and each of these files has multiple sheets, in nature each Excel file has information about a hotel b
I need help reading all the rows from excel sheet as a test data in my selenium test case. I can read only one row of an excel sheet with the following code.
I have a worksheet that uses randomly generated numbers in calculations to produce results in two adjacent cells (let's say A1 and A2). I am trying to perform
I’m trying to create a series of input boxes that will prompt for more information before executing the rest of the code. I’m stuck on the looping a
Below is my code where I'm trying to export a MS Access query output to an Excel file and then editing the Excel to create a pivot table on a new sheet. The cod
I am trying to apply filter from a master worksheet to multiple worksheets in the same workbook. eg. There are 3 worksheets in the workbook, with following fi
Whenever I open the worksheet, I wish the current Month name row to be adjusted at the top of worksheet. I entered month name in cell E2-January, then after 115
I am trying to export a MS Access query to an Excel file and then create pivot tables in the excel file based on the data dump extracted to the excel file. My i
I'm writing a program to read a large xml file and create an excel file from it. The attributes of each node will be the column headers in excel file. I created
In Workbook.Open() I have an Application.OnKey for every letter on the keyboard and all the numbers. The letters open a sub LetterPress(L as String) Example for
I'm trying to turn general data written as fractions like 3/4" or 13 7/32" into 3 place decimal numbers such as 0.750 or 13.219. I have a working table replacem
The code works when the criteria exists. I get an error when the criteria doesn't exist. ' Define constants. Const srcName As String = "wfm_rawdata" Const srcFi
I am trying to extract the email address from each individual undeliverables email body. The email body would be like: ----------------------------Email-------
I know the method as Application.Visible = False and Application.Screenupdating = False When opening the file, I want the user to see only the userform. The
Is there a way in C# to switch off macros in excel before loading an excel file. I am loading the excel file using Excel Interop. All I can see is solutions for
Does ClosedXML have any function that can be used to save an excel file as PDF? Currently i am using ClosedXML to create and populate the excel file and then u