McCall72 Posted February 1, 2008 Report Share Posted February 1, 2008 I'm pretty new to VBA and wanted to know if anyone know if it is possible to call up a macro express macro using VBA from Excel. Thanks! Quote Link to comment Share on other sites More sharing options...
paul Posted February 1, 2008 Report Share Posted February 1, 2008 Try the Help file: Macro Activation / Macro Activation / Windows API calls / Example VBA This will give you the required VB code. If you want to recode it for a scripting language, I believe you'll need to use something like AutoIt3 because, AFAIK, VB Script doesn't support API calls. Quote Link to comment Share on other sites More sharing options...
patgenn123 Posted February 2, 2008 Report Share Posted February 2, 2008 For VBscript, it should go like this: Set objShell = CreateObject("Wscript.Shell") objShell.Run "AutoFillFields.mxe" AutoFillFields.mxe is the "playable" macro I call from the desktop. For VBA, ???? Pat Quote Link to comment Share on other sites More sharing options...
blopib Posted February 4, 2008 Report Share Posted February 4, 2008 Maybe this could help: http://pgmacros.invisionzone.com/index.php?showtopic=2180 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.