Run macro from directory folder...?
 

Is there a way to execute a macro by clicking open a folder in the file
directory?

Run macro from directory folder...?
 

I don't think so.

But you may want to share more of the details.

Clarissa wrote:

Is there a way to execute a macro by clicking open a folder in the file
directory?

--

Dave Peterson

Run macro from directory folder...?
 

How would a folder have any knowledge of/connection to Excel ?

You could provide a BrowseForFolder dialog in Excel, then ... do something.
http://vbnet.mvps.org/code/browse/browsefolders.htm

NickHK

"Clarissa" wrote in message
...
Is there a way to execute a macro by clicking open a folder in the file
directory?