I use this instruction in excel but I have an error
do you know why ?
Dim Cnx As New ADODB.Connection

Greetings all
I'm trying to get excel to calculate a formula for every other row is this
possible.
Example:

Is there a way to explicitly allocate more memory to an Excel 2007
process? I'm trying to run an array formula on a huge (300k rows)
dataset and I'm getting "Excel ran out of resources while attempting
to calculate one or more formulas. As a result, these formulas

I am using Mail Merge to make labels. When I try to upload my Excel worksheet
to labels on Word it doesn't upload?

I have seen the mvp link to insert row. But I have a few different
needs. On my excel sheet, I have 2 tables, TABLE1 and TABLE2. I need to
place 2 different command buttons, one for each table, which can insert
rows on each table respectively. So when I press the button for TABLE1,

I have a bunch of columns with one of five strings on each row:
Approved
Lodged
Required

I have been trying to sort large lists of data using various formulas but to
no avail.
The problem I have is my worksheets consist of approx 50 columns for
products and 365 rows for the days of the year for each client.

Hey Folks,
Is there an easy way to send a workbook via email based on the date an
time?  Our company uses excel for some of our reporting and rather then
having the reps remember to send the workbook i'd like to have it send

I tried to drag the reference below for cell A1 through H1 but it
doesn't work. It only repeats the range G2 - G5. No increment across to
the right.
=data!$G2 for A1

1. How to add folder(s) to "look in" under Open
2. How to activated the hiden worksheets in Excel 2007.

I have a time series like this:
1995, -.05
1996, -2.1
1997,  3.6

Let's say I have a simple table with column headings of each month and I
have a starting value of 10,000 at the beginning of the year.
I want to reduce this value by a fixed percentage each month.  However,
I know I want the end result to be 8,800 after the 12 monthly

I have a sheet with 2 figures
On one of them I have put a picture by choosing properties and clicking
a jpg at the picture property..
In VBA I want to duplicate the picture from this one to the other

How do you set default column width when opening a *.csv in Excel?
Changing files in \XlStart directory did not help.
-nn

I know the HEX and RGB value of a code, but do not know the &H...
value. Anybode knows a converison tool on the web, or what is the VB
code. I want to fill it as  color value for the backgroundcolor of a
command button.