Hi all,

I have a script which runs across a directory and opens Excel files,
does a few things and then saves the files, however password protected
files are becoming a bit of a pain. When I encounter a password
protected file, Excel prompts me for a password, at this point I want to
skip the file and ignore it, however my only option is to enter the
password (which I do not have) or cancel which therefore terminates the
script.

Could anyone help me with ideas of how to skip this data?

Many thanks

-- 
Posted via http://www.ruby-forum.com/.

V2h5IG5vdCBleGFtaW5lIGEgZmlsZSdzIHByb3BlcnRpZXMgYmVmb3JlIG9wZW5pbmcgYW5kIGlm
IGVuY3J5cHRlZCBpcyBmb3VuZCB0cnVlIGluIHByb3BlcnRpZXMsIGZvcmdldCB0byBvcGVuIHRo
YXQgZmlsZT8gIEhvdyB0aGF0J3MgZG9uZSB3aXRoIHJ1YnkgSSBkb24ndCB5ZXQga25vdyB0aG91
Z2guDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFN0dWFydCBDbGFya2Ug
W21haWx0bzpzdHVhcnQuY2xhcmtlMTk4NkBnbWFpbC5jb21dIA0KU2VudDogVHVlc2RheSwgSmFu
dWFyeSAwNCwgMjAxMSAxMDoxMg0KVG86IHJ1YnktdGFsayBNTA0KU3ViamVjdDogRXhjZWwgZW5j
cnlwdGlvbg0KDQpIaSBhbGwsDQoNCkkgaGF2ZSBhIHNjcmlwdCB3aGljaCBydW5zIGFjcm9zcyBh
IGRpcmVjdG9yeSBhbmQgb3BlbnMgRXhjZWwgZmlsZXMsDQpkb2VzIGEgZmV3IHRoaW5ncyBhbmQg
dGhlbiBzYXZlcyB0aGUgZmlsZXMsIGhvd2V2ZXIgcGFzc3dvcmQgcHJvdGVjdGVkDQpmaWxlcyBh
cmUgYmVjb21pbmcgYSBiaXQgb2YgYSBwYWluLiBXaGVuIEkgZW5jb3VudGVyIGEgcGFzc3dvcmQN
CnByb3RlY3RlZCBmaWxlLCBFeGNlbCBwcm9tcHRzIG1lIGZvciBhIHBhc3N3b3JkLCBhdCB0aGlz
IHBvaW50IEkgd2FudCB0bw0Kc2tpcCB0aGUgZmlsZSBhbmQgaWdub3JlIGl0LCBob3dldmVyIG15
IG9ubHkgb3B0aW9uIGlzIHRvIGVudGVyIHRoZQ0KcGFzc3dvcmQgKHdoaWNoIEkgZG8gbm90IGhh
dmUpIG9yIGNhbmNlbCB3aGljaCB0aGVyZWZvcmUgdGVybWluYXRlcyB0aGUNCnNjcmlwdC4NCg0K
Q291bGQgYW55b25lIGhlbHAgbWUgd2l0aCBpZGVhcyBvZiBob3cgdG8gc2tpcCB0aGlzIGRhdGE/
DQoNCk1hbnkgdGhhbmtzDQoNCi0tIA0KUG9zdGVkIHZpYSBodHRwOi8vd3d3LnJ1YnktZm9ydW0u
Y29tLy4NCg0K