Need help with VB Excel statement
 

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.

Need help with VB Excel statement
 

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.

--
Regards,
Tom Ogilvy


" wrote:

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.

Need help with VB Excel statement
 

On Feb 14, 2:10 pm, Tom Ogilvy
wrote:
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.

--
Regards,
Tom Ogilvy


Thanks Tom, I appreciate it.