Vba: Open Password Protect Spreadsheets (1 Viewer)

[DALIEN51]

Hi all!

I have some Access 2000 VBA code which opens all of the Excel 2000 spreadsheets in turn in a particular folder. However, if one of the spreadsheets is password protected I want to ignore this file and move on to the next one...is this possible?

Any help most appreciated.

Neil

 

[ghudson]

Do you not get a runtime error when you try to open a password protected xls file? You can trap for the runtime error number to skip it and continue with the next file.