Search all workbooks in a folder and sub folders

2 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

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

Add pictures to a chart axis

4 Responses to “Add pictures to a chart axis”

  1. Darin Myers says:

    Great technique and one I have not seen before.

    For those that may not know, you can add a custom number format to the axis to remove the negative numbers if you don't need them. Just right-click and format the axis. Then from number choose custom, and enter the positive number format, a semicolon, keep it blank for the negative numbers, a semicolon, and then the format that you want for zero (you can use a blank here if you want to remove the zero too) For example, I would use 0;;0 for this chart.

  2. Ola says:

    Thanks for a great idea. I'll use it.
    //Ola

    Made one small improvement:
    To auto-adjust the flag position when the maximum value change.
    D3toD7: =MAX($C$3:$C$7)*(-1,5/22) -- chart size constant
    and change...Format Axis, Bounds, Minimum to Auto

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