filename

J

John Spencer (MVP)

What file name? The name of the database .mdb or .mde? Some other file?

What do you mean by "cell"? Access has controls on forms and reports. Do you
mean the specific intersection of a record(row) and field(column) in a query?

What version of Access?

Dir(CurrentDb().Name) will work in almost any version of Access to give you
the name of the Access database file.
 
J

John Spencer (MVP)

Try asking this question in an Excel group. Also, specify your version of Excel
when you do.
 
Top