First, I know nothing about access, but if you're opening the workbook in excel
(via code), you can turn off the workbook_open macro, and not update the links.


dim mywkbk as workbook
application.enableevents = false
set mywkbk = workbooks.open(filename:="....", updatelinks:=??, ...)
application.enableevents = true

Updatelinks has a few options. You can read about it in help.



Paul Christie wrote:

Does anyone know of a way of finding out if a workbook
has a code module and/or links without opening the
workbook.

I'm writing an import process into an Access Database and
I need to check the file before I open it.

Thanks for any help

--

Dave Peterson