Need to run a macro on all open workbooks

[josephjeffery]

I have a macro which fetches the input from the user once it runs and based on that input it does some activites.

All i need is am running the macro in the first workbook and giving the inputs..Based on the inputs given the macro should run the same on all the other workbooks which is open

Help on the same

 

[ClimoC]

I have a macro which fetches the input from the user once it runs and based on that input it does some activites.

All i need is am running the macro in the first workbook and giving the inputs..Based on the inputs given the macro should run the same on all the other workbooks which is open

Help on the same

From the attempt at English above...

If the same action needs to be taken on all the open workbooks, that's easy - but it sounds like you need different workbooks to have different things done to them? "Based on the inputs given, the macro should..."

If it's just the same action on every open workbook, then encase your code like this:

Sub YourSubroutineName()

For each wb in Application.workbooks

'You code goes here

'But as we can't see your script, there's no way of knowing what action it will take. So either replace all references in your code to a sheet, ie 'sht1.range(...' with 'wb.sht1.range(...'

Next