Hi, can someone please give me the syntax for Excel VB statement to
open a worksheet, which is named in "INDEX(dir, k)". In my XLM
program the statement is simply "=OPEN(dir,k)", but I can't seem to
figure out how to write it in VB. Many thanks in advance.