Does workbook contain code and links

[Paul Christie]

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]

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]

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