Top "Excel" questions

Optimal way to Read an Excel file (.xls/.xlsx)

I know that there are different ways to read an Excel file: Iterop Oledb Open Xml SDK Compatibility is not …

c# excel oledb openxml-sdk excel-interop

How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is …

excel vba excel-2003 worksheet-function

Format numbers in thousands (K) in Excel

In MS Excel, I would like to format a number in order to show only thousands and with 'K' in …

excel excel-formula

filter out multiple criteria using excel vba

I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and …

excel vba excel-2010 excel-2007

What is the difference between .text, .value, and .value2?

What is the difference between .text, .value, and .value2? Such as when should target.text, target.value, and target.value2 …

excel vba

Get User Selected Range

How can I get a range of cells selected via user mouse input for further processing using VBA?

vba excel excel-2003

VBA code to show Message Box popup if the formula in the target cell exceeds a certain value

I am trying to write a simple macro to display a pop-up (vbOKOnly) if the value in a cell exceeds …

vba excel messagebox

Create a folder and sub folder in Excel VBA

I have a pull down menu of companies that is populated by a list on another sheet. Three columns, Company, …

excel vba macos directory create-directory

Creating an Array from a Range in VBA

I'm having a seemingly basic problem but can't find any resources addressing it. Simply put, I just want to load …

arrays excel vba range

Run Excel Macro from Outside Excel Using VBScript From Command Line

I'm trying to run an Excel macro from outside of the Excel file. I'm currently using a ".vbs" file run …

excel vba command-line vbscript