sunilvedula Posted May 6, 2008 Report Share Posted May 6, 2008 HI all, just wanted to know if we can activated a macro from a command button from an excel sheet. what i want is when the user clicks the submit button my macro with name "scores macro" needs to get activated. is it possible if so how do i do that?? Also i am not so knowledgable in exccel Quote Link to comment Share on other sites More sharing options...
balithag Posted May 7, 2008 Report Share Posted May 7, 2008 You can tie the button Click event in Excel to a command like this in Visual Basic: Call Shell("C:\Program Files\Macro Express3\MeProc.exe /AYourMacroName", 1) Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted May 14, 2008 Author Report Share Posted May 14, 2008 Just a doubt! do we need to specify the location where our macro is loacted along with meproc location. Or is it sufficent if i give the location of my macro. Because when i specified the location of my macro it did not respond. It gave an error. pls suggest Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted May 14, 2008 Author Report Share Posted May 14, 2008 Also is it possible to call a excel macro in the macro express which we create . Is it possible if so how do i do that? Quote Link to comment Share on other sites More sharing options...
kevin Posted May 14, 2008 Report Share Posted May 14, 2008 do we need to specify the location where our macro is loacted along with meproc location.No, meproc.exe knows where to find your macro file. ... it did not respond. It gave an error.What was the error? ... is it possible to call a excel macro in the macro express which we createHow do you do it manually (keystrokes, mouse moves, mouse clicks)? Can you repeat those steps in your macro? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.