About Promt Window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

boltnia - 23 Nov 2007 08:36 GMT

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

Reply to this Message

Nigel - 23 Nov 2007 15:09 GMT

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.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Hi!
>
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

boltnia - 23 Nov 2007 15:26 GMT

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

Thanks :)

> Not sure why you want to do this?
>
[quoted text clipped - 14 lines]
> >
> > Thanks

Reply to this Message

Chip Pearson - 25 Nov 2007 21:32 GMT

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.

Signature

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

> Thanks. But I didnt get answer on my question. Can I prevent prompt window
> in
[quoted text clipped - 23 lines]
>> >
>> > Thanks

Reply to this Message

boltnia - 26 Nov 2007 08:01 GMT

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

> Try
>
[quoted text clipped - 3 lines]
> I would STRONGLY recommend against changing file extensions. It won't make
> the 2007 file openable in 2003, regardless of the extension.

Reply to this Message