Top "Excel-2003" questions

The Excel-2003 tag is used for referencing the Excel Version 2003 spreadsheet application from Microsoft.

Excel Workbook Open Event macro doesn't always run

I've got a Workbook_Open event macro (and it's in ThisWorkbook) that doesn't always run. If Excel is closed and …

excel events vba excel-2003
Handle Error 9 when there is an Empty Array

I am writing a script that will loop through an Excel spreadsheet and find if there are duplicates of selected …

excel vba error-handling excel-2003
Excel VBA macro: Locating first empty cell in a column and automatically filling it

I have two columns, Column (A) and Column (B) in a spreadsheet. Column (A) contains names extracted from a query (…

excel excel-2003 vba
Excel VBA - How To Insert Plain Value without Formula?

I have skimmed many Excel VBA topics, however, I have not found any information about inserting plain values - the …

vba excel excel-2003
vba: return dictionary from function

this outlines what i am trying to do. this is not working for me, and it is unclear why. thank …

vba excel excel-2003
How to write to a "Google Spreadsheet" from Excel 2003 VBA

I Have an Excel 2003 file with a line similar to this: I need to click "the button" and it adds …

vba google-docs excel-2003 google-sheets
How to delete contents of an Excel sheet in Java?

How to delete contents of an Excel sheet in an Excel workbook, using Java SE and Apache POI?

java excel excel-2003 apache-poi
Make conditional formatting static

Is there any way to convert conditional formatting to static formatting in Excel? I'm trying to export a range of …

excel vba excel-2003
Adjusting worksheet zoom level based on screen resolution

I have an Excel 2003 macro to adjust my screen zoom based on the screen resolution. Sub Macro1() Dim maxWidth As …

excel vba screen-resolution excel-2003
Validate IBAN in Excel

Is there any ready excel sheet to validate the IBAN? I will enter the IBAN and it will show valid …

excel excel-2007 excel-2003 vba