I have a external database to link MS Access Query.
I can run the query from Excel, but I need pass the start date and end date
to the query.
Are there any way to pass MS Access Query parameter from Excel Spreadsheet?

Is there a way to show the (full) name of links in a range of cells. I know
you can do this manually with "findlink", but am looking for a way that on
my "master print" also the name of all linked workbooks is shown.
Thanks in advance,

Are there any way to link the number of emails received on particular
folder?
Thanks in advance for the information,
Inung

In the office I have several hundred excel spreadsheets & many of these are
linked.
The problem that I am having is that all of the files are on a shared drive.
Four of the users are accessing the file server with a direct unc path to

We have a workbook that contains links to several other workbooks. However,
one of the links listed in 'Edit, Links' is not valid and the file no longer
exists. I have tried every tool and trick I know to find where this file is
referenced, to no avail. I have tried the Delete ...

Hi people,
Posted this to the vba newsgroup before but it seems pretty much dead and
this group seems more appropriate.
Referencing non contiguous ranges in VBA seems to become impossible for the

I input some value say in G5 on sheet1, then using this value and different
formulas to get four different results on say A5, B5, C5 and D5. (All on
same row)
Now I need this values to be transferred to Sheet2 say A10, A11, A12 and

I need to create a workbook with a text field that is linked across the
entire workbook. However, should any changes be made on any one of the
worksheets, I need the text field to automatically update the text fields on
all the other worksheets in the workbook.

I have a linked worksheet on our network.  One of the links broke and I went
ot fix it but when i pastye special i am seeing  a different screen.  This
screen dosen't allow me to paste link it says paste and gives 2 choices
unitext code and something else.  How do i get the ...

Excel 2002
I have a file on a server on the intranet:
\\shared\test\test.xls
Now I make a hyperlink in another workbook by >Insert - Hyperlink

I have a formula which works fine, but when I copy it to the next cell the
formula appears as text rather than actually doing anything.   For example
in the cell =a1+a2 appears rather than the calculation actually being
performed.  Other formulae work as normal.  Help!

When I select a jpg hyperlink from Excel 2002 SP3 I want the image to be
opened in Windows Picture and Fax Viewer.
I want to know how to control which program is used as the viewer.
Reading around, I was lead to believe the OS file association was the

I have a validation list containing a list of part numbers.  I would like
the source data to contain a blank cell at the END of the list.  Is there an
easy way of doing this?  I find that only empty cells in the middle of  the
source data are recognised.

I have a master workbook and a number of data entry workbooks contained in a
network folder.
The master workbook links to data on the data entry workbooks and the data
entry workbooks contain charts which are linked back to the master workbook

I have (from the links menu): "Don't display alert and update links..."
checked but it still comes up with a message box:
This workbook contains links to other data sources.
- To update all linked information, click Yes.