Search results

My sincere thanks go to jdgibson & Scleameth for their help - passing in a blank password string (5th param of OPEN method) and then checking if the handle to the workbook is valid worked a treat. Cheers again you guys ! One happy programmer...

Thanks for the info Scleameth - have just put that code before the OPEN as suggested but Excel still pops up with an 'Data.xls is Protected' / Password box - grrrr !

Progress 9.1E Appserver Hi All, I have an automated program that takes MS Excel XLS files as input, reads the data from the XLS and populates some db tables. The problem I am having is that some of the XLS files are password protected (they are supplied via an external source) - in this...