disable exe file

[tearskye]

i have a picture in excel that links to an exe file in windows ( eg. winword.exe)
when i click on the picture, the warning that " you are launching an exe file " comes out. does anyone knows how to disable it ? or can i use a recorded macro to disable it.

thanks

[funkymonkUK]

are you only trying to open word?

if so open VBE by pressing Alt+F11 or tools>macros>visual basic editor

then create a module in your workbook then copy and paste this

Sub Openwrd()

Application.ActivateMicrosoftApp xlMicrosoftWord

End Sub

then right click on your picture click on assign macro and then click on the macro Openwrd then test it

should open word without giving you a message.

you can open other office programs by replacing XlMicrosoftWord with either of these examples xlMicrosoftPowerPoint, xlMicrosoftMail, xlMicrosoftAccess, xlMicrosoftFoxPro, xlMicrosoftProject, or xlMicrosoftSchedulePlus.

[tearskye]

thanks a lot for your help
it really worked !

yes, i want to open office based applications
btw. what is the code for opening excel ? xlmicrosoftexcel opens the calculator~!


however, i also want to open custom exe file

any solutions for that ?

once again, thx a billion

[funkymonkUK]

how are you opening your custom exe files? if you are using a macro could you post the code up here?

[tearskye]

i am opening macros either using the hyperlink function ( browse to file ) in excel

or if there is any alternative that u can propose.

thanks

[funkymonkUK]

try using this macro

Sub test()

' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINNT\SYSTEM32\calc.exe", 1) ' Run Calculator.


End Sub

change the part that has the file structure and filename to the file you want to open. use the help function and search for "Shell Function" you can replace the 1 with customerize the window