>Hi, I want to import data from hundreds if not thousands of password protected excel spreadsheets.
>Instead of manually opening them and unprotecting them by hand, how can I modify my program, which already imports the un-protected ones, so that it can read them even tough they are password protected.
>
>I am currently using the IMPORT FROM command.
You can open each Excel file individually, and save it again, without a password. Then, the IMPORT command should work without a problem.
If you have Excel installed, the above can be automated, with Automation. If you are new to Excel Automation, see my introductory article:
http://www.utmag.com/September2002/Page45.aspIn this particular case, the Open() method (in Excel) supports a password option, so it should not be difficult to automate this.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)