Run-time Error 445: Object Doesn't Support This Action (File Search)

[Gerzim]

Hello everyone,

I searched the forums for this problem and only found a solution that was too dissimilar to help me. I know very little about coding so if anyone can help it would be appreciated.

I use a hydrology program at work which is supplied for free by Wollongong University and is accepted by all local authorities in the areas that I do this work. Notepad is used to for the input files and is very cumbersome. They also provide an excel file which uses a macro to streamline the input process (about 10 times faster) however it was written for a much older version of excel when the code FileSearch worked. Because the program is free there is no support and no updated version of the macro. Can someone show me the correct alteration to the attached code, please?

[Norie]

The FileSearch part of the code just seems to be checking if a file exists, that can be done with Dir.

So perhaps something like this.

Please Login or Register  to view this content.

[Gerzim]

Thank you Norie, I'll try it out

[Gerzim]

Thanks Norie, that worked but I am having the same problem with another macro in the same spreadsheet but with slightly different code. Do you think you could help me with the
attached code?

Thank you

[Norie]

I don't see why Application.FileSearch is being used there.

Again the code seems to be checking if a file exists, though this time it's warning you if the file doesn't exist.

That's what I think it's doing anyway, it kind of seems a bit over-complicated.

Anyway, give this a try.

Please Login or Register  to view this content.

[Trebor76]

Hi Gerzim,

Welcome to the forum!!

Yes, Application.FileSearch was removed from Excel as part of its 2007 release.

Here's my attempt at a work around:

Please Login or Register  to view this content.

Regards,

Robert

[Gerzim]

Thanks guys, very much appreciated. It seems to be running now. Hopefully I'll get to be as proficient at this as you two.

[Trebor76]

Thanks guys, very much appreciated. It seems to be running now.

You're welcome. If you could mark the thread as solved it would be appreciated.

Regards,

Robert