My users have a MS Access database with password. I was asked to write a
macro in Excel to connect to MS Access, extract the data based on a certain
criteria. Put in Excel workbook and email to a recipient automatically. Is it
doable?

I have been having the same issue for a while now, and it is now time
for me to conquer this problem, so I made a new simple spreadsheet with
ONLY the combobox and the appropriate code to try to single out the
problem.

I have a macro. I want to search my worksheets to see if there is any
worksheet that has the current date as worksheet name. however the current
date may only be part of the worksheet name eg "2006-09-19" or "2006-09-19
Vector". I do not know how to find the ones that have a name ...

Dear Anyone,
I have prepared a few excel files linked together and am planning to sell it
to a company. But they may copy and give these files to other companies to
use on their computer. I want to protect my work. Giving passwords to open

I have a worksheet with several graphs in it.
The sheet gets copied to create a new workbook then I've atempted to
Breaklinks to the original workbook by using the following code
(straight out of the online help!!).

My understanding is in a two dimensional array the second dimension has to be
the same length for each one, What I would like is to have the second
dimension to be different lengths so it only has to be the length to handle
the number of items.

In MS EXcel 2003, I have a  master workbook with 5 feeder workbooks to enable
a city manager to collect monthy returns from 5 area managers. So in Jan '06
I have CityJan06.xls with many links to NJan06.xls, SJan06.xls, NWJan06.xls,
EJan06.xls and NEJan06.xls. When all the Jan ...

My problem is I am trying to create a formula that would calculate some
figures.
FORMULA: -
IF D15 is equal to D17:D20 display result, IF not display result

I am Using MS office 2003. I want to create chart using VBA. I have
written the folowing function.
Public Function AddChartSheet(ByVal x As Long, ByVal y As Long, ByVal z
As Long)

I have a worksheet where I need to sum records in one column by another
(thus subtotals function). As you know when excel sums each group of
records it records the subtotal at the bottom of the last record in the
same column. I need excel to record the subtotal at the bottom of each

Is there a more efficient / better way of doing this?
The code below is used in a user form where the user selects a single
cell using the RefEdit control. It ensures the user only selects a
single cell, within a specified range, and a selection is actually

I have a macro that I use for comparing columns in two different worksheets.
The worksheets are identical in stucture ie there may be numbers in cells
that differ but all rows and columns look the same. I want to check a certain
column starting at the cell "b6". therefore i ...

I have a doubt
How set two conditional macros on a checkbox? For example if the checkbox A
is clicked will be executed the Macro A if not then will be executed the
Macro B.

I have a calendar 9.0 object in my sheet. How can I tell to the object
that I want it to show me allways current date as default?
hannu

Hi, I have never worked with calendar object yet, so here's my
question:
Private Sub Workbook_Open()
CommandButton1.Caption = "Import the list of matches from " &