Alexis Posted December 27, 2008 Report Share Posted December 27, 2008 I would like to start a Macro from the Mex Library by using a hyperlink in word. I already know that the command line "c:\Program Files\Macro Express3\MeProc.exe" /AName of Macro activates the macro described. But if i write this line in a word hyperlink it says something like „Adress not allowed“ What´s wrong? What already works is to put the commandline in a .txt-File and rename it as a .cmd-file. Then link this file to the hyperlink in word. But then i got two nasty security questions. Very annoying. I could use .mxe-Files but than i would have to export them after every change. Any ideas? Thank you Alexandra Quote Link to comment Share on other sites More sharing options...
rberq Posted December 28, 2008 Report Share Posted December 28, 2008 Let's say the name of your computer is MYCOMP. Instead of "c:\Program Files\Macro Express3\MeProc.exe" /AName of Macro, try using "\\MYCOMP\c$\Program Files\Macro Express3\MeProc.exe" /AName of Macro It might work.... Quote Link to comment Share on other sites More sharing options...
Alexis Posted December 28, 2008 Author Report Share Posted December 28, 2008 Thank you very much rberq Unfortunately i get the same message. It´s in German but could be translated as: The address of this website is not allowed. Check the address and try again. Did you try you try your suggestion yourself? Does it work with your word version?. By the way i´m using Office 2007. Thanks again. Alexandra Quote Link to comment Share on other sites More sharing options...
rberq Posted December 28, 2008 Report Share Posted December 28, 2008 Nope. Didn't try it myself. I was just guessing that it might work, though really it's more of a Windows network format. Why does your computer speak to you in German? Quote Link to comment Share on other sites More sharing options...
Alexis Posted December 28, 2008 Author Report Share Posted December 28, 2008 Cause i live in Frankfurt/Germany my dear! This language thing got me already once. I was desperately creating commandlines in Word (German) and couldn´t figure out what was wrong. After posting here somebody worte: "Hey whats wrong with you exclamationmarks?" In Germany we use two different ones: „Text“. Of course no pc understands that. ;-) So do you have any other ideas when it comes to Clicking to fire macros in word? Thank you Alexandra Quote Link to comment Share on other sites More sharing options...
rberq Posted December 29, 2008 Report Share Posted December 29, 2008 Sorry, no more ideas. But I must say your English is better than my German. Quote Link to comment Share on other sites More sharing options...
terrypin Posted December 29, 2008 Report Share Posted December 29, 2008 I would like to start a Macro from the Mex Library by using a hyperlink in word. I already know that the command line "c:\Program Files\Macro Express3\MeProc.exe" /AName of Macro activates the macro described. But if i write this line in a word hyperlink it says something like „Adress not allowed“ What´s wrong? What already works is to put the commandline in a .txt-File and rename it as a .cmd-file. Then link this file to the hyperlink in word. But then i got two nasty security questions. Very annoying. I could use .mxe-Files but than i would have to export them after every change. Any ideas? Thank you Alexandra I just tried this with a similar shortcut: "C:\Program Files\Macro Express3\MacExp.exe" /APosition & size GE & Mem-Map (The macro works fine, positioning and sizing two program windows, Google Earth and Memory-Map.) But the hyperlink that ends up in Word 2000 is only the executable: C:\Program Files\Macro Express3\MacExp.exe I don't see why the other parameters would be included? But you obviously do, so maybe I'm missing something? On clicking the link, I get the familiar warning message about macros (VBA macros in this context) and on clicking OK that's all I see (presumably because MacExp.exe is already running). -- Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Alexis Posted December 30, 2008 Author Report Share Posted December 30, 2008 Well Terry, the other parameters behind the /A specify the macro to trigger. It´s simply the name of the macro. My line executed in Start or as a cmd works but not as a word link. Notice the difference between MacExp.exe and MeProc.exe. Alexandra Quote Link to comment Share on other sites More sharing options...
terrypin Posted December 30, 2008 Report Share Posted December 30, 2008 Well Terry, the other parameters behind the /A specify the macro to trigger. It´s simply the name of the macro. Yes, I know, but my question is why would you expect that additional information to be acceptable as part of a hyperlink? My line executed in Start or as a cmd works but not as a word link. Notice the difference between MacExp.exe and MeProc.exe. Alexandra -- Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Alexis Posted December 30, 2008 Author Report Share Posted December 30, 2008 Well, i don´t expected it. I hoped it would work. I have not much experience in commandlines or valid link formats. Why don´t you tell us what you know? Imagine that i do know nothing but i am eager to learn. What can i do? Thanks. Alexandra Quote Link to comment Share on other sites More sharing options...
kevin Posted December 30, 2008 Report Share Posted December 30, 2008 A hyperlink is meant to bring up a web page. To run a macro you need to be able to run a program. I don't know of a way to do that from within Word but you could check on the MS Word forums. 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.