I have added this to one line. I still get the same'424'
object required error. After doing some trouble-shooting,
the problem is the & Months.value in the code. It does
not appear it is recognizing that for some reason
-----Original Message-----
Jeff,

personally, I would just use:

Workbooks.open
filename:= "H:\GO\FINANCE\FUNCTION_LABOR\MKTG\" &
Months.value & "\MKTG_GROUP.XLS"

Although I'd probably type it on one line!!

Cheers, Pete
.