Search:

Hi Steve - I have a workaround. I simply rem'd the second Open command (the one with Password:= sPW2) and ran the macro. It unprotected all the files in my test sample (6) that matched password sPW1....

Regrettably Steve I got an Automation Error (-2147221080 stopping at wkb.SaveAs FileName:=strPath & "\" & strFile, Password:="") which I can't find on Microsoft site.
Below is the code with my...

Thanks for your reply Steve; does this make it clearer?

From what I can see I need to consider the folder contents as a collection or array for VBA purposes, but I don't know how to do that.

My apologies to all that have replied so far - I actually meant workbooks are protected. Some have one password and others another. But there are still >5000 of them and although I appreciate the...

I wish to add my thanks to HansV for his assistance over the years. Where I saw clutter or darkness, he saw order and light.

May Hans enjoy thoroughly anything he to which he puts his hands.

Yes Catharine, that is exactly what I want to do and they are all in the same folder fortunately although the passwords can be one of two different PWs.

Any suggestions greatly appreciated.

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi - I have not been back for quite some time to the new Lounge and it is quite impressive.

However I find the search facility brings up too many (irrelevant) results. Therefore I would like some...

Hi Hans - from a more thorough search of the Lounge I can reveal the code probably came from another source... <g> (This was the one I was thinking of - Post: 141,597)

But I have no idea where the...

Thanks Hans - but so that there is nothing 'extra' appearing (or hidden) in the current open workbook, I did not wish to create a temp worksheet but use a VBA form to display the results of the...

Some time ago I worked on some code that allows an Excel user to print a label containing a name and 3 lines of address from a workbook. The workbook uses a VLOOKUP to retrieve the details from...

Thanks Hans - I was able to use this code to do exactly what was needed. Now to go back and study what you did.

The code was surprisingly fast even when I turned on screen updating. I'll have to...

Sorry about the delay in replying but please offer suggestions re the code in the attached book.

Thanks Hans - Firstly I meant Name is a heading. It refers to a business name that is extracted from the finance app. There can be about 500 on each extracted sheet and I need to find each so that...

I have a spreadsheet that is dumped from a financial package.

It lists name, address, and phone details that I want to extract from Sheet1 and paste into a layout (that is easier to read) on a...

Alan, Chris, Don and Kim - the good news is that it now runs the way it should. While the efforts of everyone who offered their suggestions, recommendations were very much appreciated, it was Hans...

Thanks Kim and Don and Hans

If I can't get another way to resolve this I might have to resort to invoking Word. But as Hans said, I believe it increases the overhead and I would like to keep it...

Thanks for your input Chris - However I need the INI file to be untouched as it contains data that the users need to use but not modify. I can't have any chance of the INI being deleted therefore the...

Hi Alan - I had a look at the vbAccelerator site and tried to work with the CLS file but got error message about the form class not being supported in VBE.

However if anyone can see the way to use...