How to skip the current file when using strFile = Dir(strPath & "*.xlsm")

[kpierce]

I have received a lot of help on this form and I thank you.

I want to read through all the *.XLS* files in a given directory.

I would like to put the XLS* file with the macros in the same directory, but don't want to read that file.

Currently I have this working by having the master XLS* in a different directory. And I am now to the point I would like to put everything in one directory.

* I have the following line working
strFile = Dir(strPath & "*.xlsx")

*I would like to do something like.
If strFile = Me or Execute File...

I could easily require the master file always have the same name, but don't know if that would work.

In summary

in the same directory
MASTER.XLSM
FILE1.XLSM
FILE2.XLSM
FILE3.XLSM

I will open MASTER.XLSM and execute a macro to read all the XLSM files in the current directory, but I don't want to skip MASTER.XLSM.

Thanks <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[Ruddles]

I will open MASTER.XLSM and execute a macro to read all the XLSM files in the current directory, but I don't want to skip MASTER.XLSM.

Thanks <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

I assume that's a typo.

Your workbook is called ThisWorkbook.Name, so your code would be:-

[FONT=Fixedsys]If strFile<>ThisWorkbook.Name Then[/FONT]
[FONT=Fixedsys][COLOR=green]   ' file isn't me - process this file[/COLOR][/FONT]
[FONT=Fixedsys]End If[/FONT]

Also, your path is ThisWorkbook.Path.

 

[kpierce]

Thank you so much