Workbooks(Progname).Activate

"maperalia" wrote:

I want to know how can I active a window. I have the statement written (see
below) ,however, it is not working. The "Progname" is already open with
another files and I want the "Progname" to be the active one when the macro
is done.

Thanks advance.
Maperalia

"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Progname = "S:\GEOTEST\shears\" & WO & "\" & Boring & " " & "@" & " " &
depth & ".xls"
Windows(Progname).Activate