On Aug 20, 5:25 pm, "Don Guillett" wrote:
Sorry. try this
Application.Run InputBox("Enter sub to call")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John Cole, Jr." wrote in oglegroups.com...



On Aug 20, 3:16 pm, "Don Guillett" wrote:
how about
call inputbox("Enter sub to call")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John Cole, Jr." wrote in
ooglegroups.com...

I have written a macro that will loop through every workbook in a
certain directory. I would like to use that for several other macros
that will do things in the workbooks. Is there a way, I can use an
InputBox to call the routine/sub I want to run with the Loop
procedure?

Thanks in Advance,

JC- Hide quoted text -

- Show quoted text -

Tried that, and I got an error.

JC- Hide quoted text -

- Show quoted text -

....Like a charm.
Thanks a lot!

JC