Excel VBA Macro

  • Thread starter Thread starter Sheela
  • Start date Start date
S

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
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
 
Back
Top