Search:

Type: Posts; User: LeighW; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.05 seconds.

  1. Hi Steve - I have a workaround. I simply rem'd...

    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....
  2. Regrettably Steve I got an Automation Error...

    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...
  3. Thanks for your reply Steve; does this make it...

    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.
  4. My apologies to all that have replied so far - I...

    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...
  5. Replies
    103
    Views
    12,501

    I wish to add my thanks to HansV for his...

    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.
  6. Yes Catharine, that is exactly what I want to do...

    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.
  7. Hi - I have not been back for quite some time to...

    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...
  8. Hi - I have not been back for quite some time to...

    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...
  9. Hi - I have not been back for quite some time to...

    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...
  10. Hi - I have not been back for quite some time to...

    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...
  11. Hi - I have not been back for quite some time to...

    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...
  12. Hi - I have not been back for quite some time to...

    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...
  13. Hi - I have not been back for quite some time to...

    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...
  14. Hi - I have not been back for quite some time to...

    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...
  15. Replies
    4
    Views
    1,846

    Re: Adding Data to a Form (VBA/Excel/2003)

    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...
  16. Replies
    4
    Views
    1,846

    Re: Adding Data to a Form (VBA/Excel/2003)

    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...
  17. Replies
    4
    Views
    1,846

    Adding Data to a Form (VBA/Excel/2003)

    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...
  18. Replies
    6
    Views
    1,244

    Re: Using Find for Data (VBA/Excel/2002-3)

    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...
  19. Replies
    6
    Views
    1,244

    Re: Using Find for Data (VBA/Excel/2002-3)

    Sorry about the delay in replying but please offer suggestions re the code in the attached book.
  20. Replies
    6
    Views
    1,244

    Re: Using Find for Data (VBA/Excel/2002-3)

    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...
  21. Replies
    6
    Views
    1,244

    Using Find for Data (VBA/Excel/2002-3)

    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...
  22. Replies
    31
    Views
    9,516

    Re: Read from INI File (VBA/Excel/2003)

    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...
  23. Replies
    31
    Views
    9,516

    Re: Read from INI File (VBA/Excel/2003)

    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...
  24. Replies
    31
    Views
    9,516

    Re: Read from INI File (VBA/Excel/2003)

    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...
  25. Replies
    31
    Views
    9,516

    Re: Read from INI File (VBA/Excel/2003)

    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...
Results 1 to 25 of 245
Page 1 of 10 1 2 3 4