I have a macro which opens a specific file. I would like to check to see if that file is open so that there is no error on running the macro.
I would like something along the lines of
If workbook x is open then
activate workbook X else
open workbook x
end if
Thanks
Stewart
I would like something along the lines of
If workbook x is open then
activate workbook X else
open workbook x
end if
Thanks
Stewart