Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for VB Code to Link to Program
HELP!!!
I am seeking help on linking to another program from a message box "OK" button... I have created a macro that is linked to a check off sheet so that when the user clicks on a "no" response, a message box pops up telling them what they need to do. I want to link the "OK" button to the pathway that takes them to the application that they need to go to... My code looks like this... Sub Formlink() 'make sure we want the report. answer = Notify("Link Form To Task.") 'If user clicks OK, link to PowerChart. If anser = vbOK Then Application.Open_ "M:\WININTEL\DCPtools.exe" End If End Sub 'Standard message box. Function Notify(msg) 'title. msgboxTitle = "Directions:" 'buttons and icon. btns = vbOKCancel Notify = msgbox(CStr(msg), btns, msgboxTitle) End Function Sub Template() 'capture the app UseTerminalApp ImportStockFile FormatStockData FormatChart PrintChart End Sub It doesn't work...I don't know how to link to an application from a message box button... Thanks in advance to anyone!!! PM_24_7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
program link | New Users to Excel | |||
Searching Multiple Timesheets for a project code and then.... | Excel Worksheet Functions | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
VBA code to searching for a folder | Excel Discussion (Misc queries) | |||
searching by number or code ina work book | Excel Discussion (Misc queries) |