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

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

Dave,

Thanks for this I guess this will have to do. I just felt
there ought to be a way of checking for code before you
open it as a virus protection thing. Some companies in UK
pass spreadsheets around as though a spreadsheet couldn't
contain a virus but of course we know otherwise don't we.

Paul
-----Original Message-----
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

.