By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Opening Excel spreadsheets: How to get past security warning?

P: n/a
I'm writing a loop that Dir$'s through about a hundred MS Excel spreadsheets and
extracts info from maybe 5-20 workbooks within each into a staging table.

Problem is that I don't think I have any control over the user's MS "security
level"....which I think has tb set to "low" in order not to get a macro warning
every time MS Access opens up a sheet.

Per another thread, the "Certificate" route does not sound practical.

Is there some other workaround I can try? Maybe running a non-Excel utility
that converts the sheets to some more benign format?
--
PeteCresswell
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.