FiveTech Software tech support forums

Hi Everybody,

There is an option in Excel to use a password to OPEN an excel file.

How can I set this password from within FWH and how would I then use it to open the file once it is set?

Hi,
Try this

http://fivetechsoft.com/forums/viewtopic.php?t=8596

Excellent. Thanks fleal.

Now, how can I send then password when opening the file so the user does not have to enter it every time?

I found a post that mentions trying:

oExcel:WorkBooks:Open( cFileXls, , , , "password" )


But this did not work.

Any ideas?

I've got it working.

To send the password you need to do the following:

oExcel:WorkBooks:Open( cFile,0,.f.,5,"password" )