Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following code to open a read only, non-visible spreadsheet. I
would like to be able to pop a dialog box/File search window if an error occurs. This way the user can search for the file if it has been moved. What do I need to add/call to make this happen? '============================ Open LE Read Only and Invisible ===================== On Error Resume Next 'Range("b3") = MyPath & LE_Actuals & Arr(i) If Dir(MyPath & LE_Actuals & "\" & Arr(i)) < "" Then Workbooks.Open (MyPath & LE_Actuals & Arr(i)), 0, ReadOnly:=True ActiveWorkbook.Windows(1).Visible = False End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct Erro | Excel Discussion (Misc queries) | |||
Macro erro | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) | |||
WORKBOOKS.OPEN (URL) - How to trap a connection-lost/ timeout erro | Excel Programming |