Need help with VB Excel statement

[programmernovice]

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.

 

[Tom Ogilvy]

workbooks.Open FileName:=Dir, UpdateLinks:=k

This assume the variable Dir holds a fully qualified path with filename or
if the file is in the default directory/drive, then just the filename.

However, there is a VBA function named Dir, so you might want to use a
different variable name for this variable.

 

[programmernovice]

workbooks.Open FileName:=Dir, UpdateLinks:=k

This assume the variable Dir holds a fully qualified path with filename or
if the file is in the default directory/drive, then just the filename.

However, there is a VBA function named Dir, so you might want to use a
different variable name for this variable.

Thanks Tom, I appreciate it.