Hi!

So, Chip Pearson, now you are faced in my problem. I have a file .xls and I
do not know, is there Excel 2007 of 2003 format, because file with password
(file is encrypted). And I could not prevent prompt window, that informs me
about different formats. Who can help me to resolve this problem?
Thanks :))))

"Chip Pearson" wrote:

Try

Workbooks.Open Filename:="C:\Book5.xls", _
Password:="abc", writerespassword:="abc"

I would STRONGLY recommend against changing file extensions. It won't make
the 2007 file openable in 2003, regardless of the extension.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)