Top "Excel-2003" questions

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

Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been …

excel vba loops excel-2003
Conditional Formatting (IF not empty)

How do I conditionally format a cell so if not blank it is grey? I tried to do 'not equal', …

excel excel-2003 conditional-formatting
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
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
Is there a macro to conditionally copy rows to another worksheet?

Is there a macro or a way to conditionally copy rows from one worksheet to another in Excel 2003? I'm pulling …

excel copy excel-2003 worksheet vba
VBA - Run Time Error 1004 'Application Defined or Object Defined Error'

I have an Excel document that copies a template sheet into a new sheet on the first time it runs. …

vba excel excel-2003
Excel add one hour

I have in cel A1 with the following contents: 7:30:43 which is a time. But now i want to use a …

excel excel-2003
PHPExcel how to set cell value dynamically

How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I …

php excel-2003 export-to-excel phpexcel
POI setting Cell Background to a Custom Color

I want to set custom color to a cell's background. I use HSSFWorkbook (can't use anything else). HSSFPalette palette = aWorkBook.…

java apache-poi excel-2003
How do I auto size columns through the Excel interop objects?

Below is the code I'm using to load the data into an Excel worksheet, but I'm look to auto size …

c# excel-2003 excel-interop