Excel VBA Macro

[Sheela]

Hello,

I want to check if this statement is correct in excel VBA:

Const DataPath = "U:\DATA\PROGRAM\"

Workbooks.Open Filename:=DataPath + "MOPS.XLS"

Please advise. Thanks

Sheela

 

[Andy Pope]

Sheela,

It appears correct.
Although personally I would use & instead of + when concatenating.

Hello,

I want to check if this statement is correct in excel VBA:

Const DataPath = "U:\DATA\PROGRAM\"

Workbooks.Open Filename:=DataPath + "MOPS.XLS"

Please advise. Thanks

Sheela

--

Cheers
Andy

http://www.andypope.info

 

[Tushar Mehta]

What am I missing? Wouldn't it be easier, quicker, and simpler for you
to check it on your own machine?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions