I am using the ExecuteExcel4Macro to extract data from multiple workbooks
without having to open them first. It works very well until the routine
encounters a wb that is password protected. When this happens; the routine
prompts for a workbook password; is there a way around this? The password
for these workbooks is calculated based on the name of the workbook so the
password is always known to the routine; I just haven't been able to figure
out how to automate (pass) the password so that the user is not prompted for
it.

Thanks in advance for any assistance that is provided toward resolving this
issue.

-Ralph