Run-time erro '445' : Object doesn't support this action

**Aswathy** · 11-03-2008, 04:33 AM

Hi All,

While clicking a button in the excel, am getting a run-time error. Anybody knows why this error happens.

Hi All,

Everybody's need is urgent even I understand boss. Anybody else who is in the same shoes as mine. Here goes the solution:

Please Login or Register  to view this content.

**DonkeyOte** · 11-03-2008, 04:39 AM

We would perhaps need to see your code ??

**Aswathy** · 11-03-2008, 04:57 AM

Hi,

I am not able to attach the code since its too long but the line that is encountering the problem is

Please Login or Register  to view this content.

**Leith Ross** · 11-03-2008, 05:19 AM

Hello Aswathy,

From what you posted, the code statement is incomplete. Here is an example...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**Aswathy** · 11-03-2008, 05:30 AM

Hi Leith,

Yeah that is the code. But since now my excel version is 2007, am not able to use the FileSearch . Is there any other way to do a File Search.

Please Login or Register  to view this content.

Please help. Need this very urgently.

Thank you
Aswathy

**DonkeyOte** · 11-03-2008, 05:32 AM

everybody's need is urgent...

have a look at FindFile method perhaps ?

(or if this doesn't fit your need try googling VBA Excel 2007 FileSearch -- there are lot of people in your position I think :-( )

Run-time erro '445' : Object doesn't support this action

LinkBack

Thread Tools

Rate This Thread

Display

Run-time erro '445' : Object doesn't support this action

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions