| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Message for not value found
I have a program that open an excel file from select cell by asking the work
order number (see below). What statement do I need to get a window message when I type the wrong work order number?. Thanks in advance. Maperalia Sub Open_xls_File() WO = Application.InputBox("Enter Work Order Number") directory = "C:\Test\Colors\" & WO & "\" filetext = Selection.Value Workbooks.Open directory & filetext End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message refers to Name that can't be found | Excel Discussion (Misc queries) | |||
| The message EUROTOOL.XLA!fshow TTO Dialog cannot be found | Excel Discussion (Misc queries) | |||
| Style 'Percent' not found error message. | Excel Discussion (Misc queries) | |||
| Getting the message: Style 'currency' not found | Excel Discussion (Misc queries) | |||
| If not found get a message | Excel Programming | |||
Threaded Mode
