Top "Excel" questions

Removing the password from a VBA project

How can I programmatically remove a (known) password from an Excel VBA project? To be clear: I want to remove …

vba security excel password-protection

Stop Excel from automatically converting certain text values to dates

Does anyone happen to know if there is a token I can add to my csv for a certain field …

excel csv import

Test or check if sheet exists

Dim wkbkdestination As Workbook Dim destsheet As Worksheet For Each ThisWorkSheet In wkbkorigin.Worksheets 'this throws subscript out of range …

excel vba scripting

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address …

excel if-statement excel-formula excel-2013 excel-match

Remove #N/A in vlookup result

How do I modify this function so that the result will merely be a blank cell rather than having #N/…

excel vlookup

automatically execute an Excel macro on a cell change

How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my …

excel vba automation

How to export DataTable to Excel

How can I export a DataTable to Excel in C#? I am using Windows Forms. The DataTable is associated with …

c# excel datatable

Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does …

c# .net excel ms-office

Ignore Duplicates and Create New List of Unique Values in Excel

I have a column of values that often appear as duplicates. I need to create a new column, of unique …

excel excel-formula excel-2010

How do I put double quotes in a string in vba?

I want to insert an if statement in a cell through vba which includes double quotes. Here is my code: …

excel vba double-quotes