Macro to remove PW Protection in 2003 xls, Showing different behavior for xlsx files

Hi,

i have some files which I use a macro to PW unprotect. Ive created eerything in 2003 because mostly were dealing with people with older technology. However alot of them are coming back as xlsx files.

I have the following

Please Login or Register  to view this content.

Now this works fine for xls. However xlsx files the password box comes up and you have to enter the PW manually. Then the macro goes onto complete successfully.

Is there any way to deal with this at all. Any extra code i could add or any tips. OTher wise Im stuck with a anual process for these files

Debbie

Hi,

As far as I'm aware there is no difference between 2003 and 2007/2010/2013 in this respect.

What's the whole code since your MyFile variable doesn't change in the code you've posted.

Have you tested a file that's been created in 2007 or later and saved as both a 2003 and 2007+ file. That would eliminate any compatibility problem.

Incidentally when you wrap code in code tags, use the # icon on the forum so that they are automatically applied rather than manually adding. You're using <> whereas the forum uses []

Originally Posted by DebbieEdwards

I havent.

The files are coming from lots of different sources but the original file that was sent to everyone was created in 2003.

Thanks for the advice re the code blocs

Worth trying. It's unlikely but possible I suppose that there's some difference in this area with a .xls 97/2003 file created with 97/2003 and a .xls file created from XL 2007+

Let us know how this test goes.