I need help with this macro. Every time I run it, I get the error below. I thought it was a simple macro that I could have anybody on my team use to make it t
I am trying to create an excel sheet for shipping products using C# and HTML table. The image shown below is my HTML as it looks in the browser. What I am tryin
My problem is that an Excel spreadsheet (exported from Access as .xls) has cells that look empty, but are not. This is mucking up my calculations & navigati
I tried the following to filter (between filter) my worksheet based on 2 values. The 2 values are input in textbx1 and textbox2 in userform 'A1_Filter_Range'.
I have a lot of PDFs to convert to excel. I found the code below which converts PDF to excel by opening the pdf file in word but it fails at Dim fso As New File
I have a column with 595 rows. Then I proceeded to add 20. (Note this excel sheet with the 595 entries was already in place before I started working on it. The
I have been using this code in office 2013: With OutMail .Attachments.Add fName .HTMLBody = .HTMLBody & "<br><B>" &
I am trying to set some custom(from hexcode or rgb value) color to a xssfcell.But the color of the cell is becoming black even though I am giving some other col
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