Regarding opening a workbook...

[jenrique.cerda]

Hi, I have a button which when I click on it another workbook opens....

If I make changes on the recently opened workbook, how can I tell my button on VBA that if it is already opened just to dispaly that window instead of opening it again and avoiding the "If you open this you`ll lose your changes" textbox..

Thanks.

 

[Boller]

Dim wb%
On Error Resume Next
wb = Len(Workbooks("YourFileName.xls").Name)
On Error GoTo 0
If wb = 0 Then
    'Code to open the file
Else
   Workbooks("YourFileName.xls").Activate
End If