Macro to open workbooks and resize columns not working

[maym]

Hi, I have the following code to open each workbook in a directory and then to call a macro to resize the columns, however it is not working (no error messages, just nothing happening):

Please Login or Register  to view this content.

Resize macro is here:

Please Login or Register  to view this content.

Is there something I have missed with this?

Thanks

[alansidman]

Not sure if this will make a difference, but change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Crooza]

I got your macro to open the files with your original syntax but it wouldn't call the sub routine 'resize' but if I replaced

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

( you don't need the .select line)
then it seemed to work

[maym]

thank you. It worked and I also changed to files to .xls which worked as well.