View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] macmeldrum@yahoo.co.uk is offline
external usenet poster
 
Posts: 8
Default VBA open workbook xlxs in 2003 that contains a password

Hi,

I have a folder a 5 files (one of them has a password to open it).
They are all xlxs and I am working on 2003 with the file convertor
installed.

I have the following vba workbooks.open(file, false, true,
"IncorrectPassword")

What I would like to do is if I come to the file with the password not
open it and just move on.

Instead I keep getting the password open display and I don't want to
have to click out of it.

Any help much appreciated.

Mac