Easy access-button to Access-database in Excel

[Chris-data]

Hello,

we have made an excel-sheet which is connected to an access-database
with the add-on template-guide
(http://www.microsoft.com/downloads/...FamilyID=E01EA3D8-094D-4ED1-88DA-F4B8B2AD28BD).
It is working fine but we would like there to be a button which is
linked to the access-database connected with this sheet or at least a
cell which has the path to the file.
Does anybody know if this is possible?

Kind regards,
Chris

 

[CLR]

You can use the Macro Recorder to record a macro while going through the
steps manually to access the database. Then, create a drawing object and
assign the new macro to it.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Chris-data]

Thank you for helping.
Since it is a template and it is used to make many documents i am not
wuite sure it will help because then the access-document will be
different every time.

/Chris

CLR skrev: