macro parameter

[Souris]

I would like to make a macro to accept parameter from excel?

Does the macro support to accept parameter?
If yes, can it pass from Excel spreadsheet?
If not, is it possible to update a temp table from excel and using the data
from acess application or I can run Access functions or procedures with
parametrs and called from excel spreadsheet.

any other ideas appreciated,

 

[Steve Schapel]

Souris,

It is a bit difficult to understand what you mean by "parameter from
Excel", without knowing the context or what you are trying to achieve.

There are a number of ways in which Excel and Access can interact. From
the Access end, data can be exported to Excel, or imported from Excel.
In addition, with Office Automation using VBA, you can manipulate Excel
data in worksheets etc from within an Access application.