How can I programatically export data from Access to a selected file and
worksheet?  Can do macro or VBA.
(I can do the export but I can't find a way to address the worksheet.)
Thanks.

I want to place a Excel workbook on the web server and create a URL
link to it and when the user clicks on it to the URL/vbscript behind
it must launch Excel on the client and open the URL linked Excel
workbook automatically.

I have a workbook which contains several worksheets which are used to
calculate information for a report. The report pages are the first couple of
worksheets formatted and which contain graphs linked to data on other
worksheets within the workbook. I wish to make a stand alone ...

Is it possible in Excel to have a hiiden hyperlink in a
cell, so that it is invisble to those that are looking at
it , may simply be a labbel but double clicking on it
jumps you out to that wb link ?

I have spent more hours than I care to admit trying to figure out the
code for copying rows that have updated date to a master sheet.  I
have a command button on the bottom of four sheets that I want the
user to press and send information that has changed to the master

I have an EXCEL file (named 'Master') with 2 worksheets.
On each of these worksheets I have formulae which links with data on 2
different EXCEL files (named 'Data 1' & 'Data 2'). These 2 files only
hold tables containing data inputs (i.e. no formulae).

I have a cell that references a named cell on another worksheet within
the same workbook. I save and retrieve the first worksheet for
storage. Upon retrieval the cell value is set to "#NAME?" even though
the formula says it is set to the named cell. When I double-click the

I need a method to extract the list of documents an excel document is
linked to *without* opening the file (or, if it definitely has to be
opened, whe need the non-unc named links .
In other words: Lets say I have an excel document called

Greets all,
   I created a time-clock sheet at work where excel logs the times that
employees clock in or out.  This part works without a hitch.
   However, my supervisor wants the program to also track the amount of

I try to make a variable link from Excel into word, like this
{LINK Excel.Sheet 8 "ActiveDockument" "ActiveSheet!R1C1" \a \t}
But it does not work properly,
Anyone able to help.

I like to create links to cells in the current excel spreadsheet. This
because the spreadsheet name
changes, but cell information is in the same place.
Does anyone know how to do that.

In a command button, I have the following code:-
Call PutBvar("SYMBOL", Range("A8"))
This passes the value of A8 into a variable in another
program.

Table A has some real values in it ...
  Table A
  | A       | B
1  | apples  | 8

I have an Access database that's secured with a .MDW. I can't find a way to
reference the MDW file when I try to run a query via the "Get External Data"
option. Any ideas?

Is this possible?  Want to have a Master Document (source)
feeding into several sheets of a Destination Document so
using links (cell links and paste special several cell
links).  All ok and updates.  However, want to rename the