How do I automatically enter an Excel password?

[buddyrich2]

I am writing a script to automatically import an Excel spreadsheet into a VFP table but it is password protected.

Can anyone tell me how to automatically enter the password?

Thanks in advance.

 

[brigmar]

First five parameters of the Workbooks.Open method:
filename, updatelinks, readonly, format, password

so oWorkBooks.Open("Filename.xls",,,,"password") should do you.