Find a sequence

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Search all workbooks in a folder and sub folders

3 Responses to “Search all workbooks in a folder and sub folders”

  1. Andrew Evans says:

    Have you thought about adding -
    Application.ScreenUpdating = False at the start and
    Application.ScreenUpdating = True at the end
    as it will stop all the frantic screen changes when the macro is running?

    It also left the last file opened open.

    There is also something not quite right if one of the files is password protected - the next couple also showed up as password protected but with a link.

    See below (I have lined up the columns as they appear in the sheet)-
    Search string: Flexi
    Path: C:\Users\AEvans\Documents\
    Folderpath Workbook Worksheet Cell Address Link
    003474-Disc-wastage.xls Password protected
    Access to offices.xls Password protected
    Bank Account Balance.xls Password protected Sheet4 $A$540 Link
    Bank Account Balance2.xlsx Password protected Sheet4 $A$715 Link
    endeavour usage.xls Password protected Sheet4 $A$542 Link
    C:\Users\AEvans\Documents\AEvans\ Accountancy Usage 20030818.xls Sheet4 $A$700 Link
    C:\Users\AEvans\Documents\AEvans\ accountancydiscusage.xls Sheet4 $A$453 Link

    • Oscar says:

      Andrew Evans,

      Have you thought about adding -
      Application.ScreenUpdating = False at the start and
      Application.ScreenUpdating = True at the end
      as it will stop all the frantic screen changes when the macro is running?

      No, I used it for monitoring the process but it is a great idea. It may also speed things up.

      It also left the last file opened open.
      There is also something not quite right if one of the files is password protected - the next couple also showed up as password protected but with a link.

      I will look into that.

      Thank you for commenting!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

List of all comments (excel vba)

One Response to “List of all comments (excel vba)”

  1. Ola says:

    The starting point of a Circular reference errors isn't always so easy to find.
    http://www.extendoffice.com/documents/excel/1049-excel-identify-locate-circular-reference.html

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Use pictures in a column chart

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Build a comparison chart

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file