Does workbook contain code and links

  • Thread starter Thread starter Paul Christie
  • Start date Start date
P

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
 
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.
 
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
 
Back
Top