About Promt Window

[boltnia]

Hi!

I have file .xlsx with password. If I rename file to .xls and try to open
this file, Excel 2007 ask me password and then it is generated prompt Window
with message like "Actual format of document is different from format given
by extension. Open this file?" So, can I prevent this prompt window? May be I
have to change some parameters in call method Workbooks.Open?

Thanks

 

[Nigel]

Not sure why you want to do this?

The xlsx and xls formats are very different. If you want an older xls
version then save the file as Excel 97-2003 format from within Excel. This
creates a file with the xls extension.

 

[boltnia]

Thanks. But I didnt get answer on my question. Can I prevent prompt window in
discribing earlier situation? If yes, how?

Thanks

 

[Chip Pearson]

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)

 

[boltnia]

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 )))