Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open window - on error
Sub Opendefactivewkbk()
On Error GoTo ErrorTrap1 ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path FName = Application.GetOpenFilename() ErrorTrap1: ChDrive "D" FName = Application.GetOpenFilename() If FName < False Then Workbooks.Open FName End Sub The above macro works well without the on error - however i need it in case i want to open a file from an active workbook which has not yet been saved. My problem is that I have 2 open window appearing one after the other if there is no error. an anybody correct my code pls thxs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I can I open a small window within window | Excel Discussion (Misc queries) | |||
OPen an DOS WIndow | Excel Discussion (Misc queries) | |||
open new window | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Error on activating a window a open workbook | Excel Programming |