Linking to an Excel File w/o locking

[stickandrock]

I have an Excel file that I want to set up a link to in my Access DB. The
problem is I only want to use it as a reference (never to be updated through
Access). When I Link to it, it locks it from others using it in Excel on
their workstations.

I can import it, but I wanted something that was more automated. I don't
want to be in the habit of always having to make sure I re-imported the
latest version of the Excel file.

Any input would be greatly appreciated.

 

[Tim Ferguson]

I can import it, but I wanted something that was more automated. I
don't want to be in the habit of always having to make sure I
re-imported the latest version of the Excel file.

You could always automate the import...


Tim F

 

[stickandrock]

I know how to manually import, but not sure how to convert that into a macro.
I know how to automate a macro to run, just not sure how to code it.