About Promt Window
 

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

About Promt Window
 

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.

--

Regards,
Nigel




"boltnia" wrote in message
...
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

About Promt Window
 

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

Thanks :)


"Nigel" wrote:

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.

--

Regards,
Nigel




"boltnia" wrote in message
...
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

About Promt Window
 

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" wrote in message
...
Thanks. But I didnt get answer on my question. Can I prevent prompt window
in
discribing earlier situation? If yes, how?

Thanks :)


"Nigel" wrote:

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.

--

Regards,
Nigel




"boltnia" wrote in message
...
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

About Promt Window
 

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)