File Structu

H:\
GO
Finance
Function_Labor
MKTG
JUN
MKTG_GROUP.XLS
JUL
MKTG_GROUP.XLS
AUG
MKTG_GROUP.XLS


VBA Code:

Sub MKTGRPsumm()
ChDrive "H"
ChDir "H:\GO\FINANCE\FUNCTION_LABOR\MKTG\" &
Months.Value
Workbooks.Open Filename:="MKTG_GROUP.XLS",
Password:="MKT2646"
End Sub ''


Scenario:

Combobox(Months) with a list of months. User selects
month in combo box then clicks on button tied to macro
above. The object is to have the user select the month of
the report to open.

Error:

Receive the following error when executing the macro:

Run-time error '424'
Object Required


Can anyone help fix this code? Thanks

Hi Jeff,
What does months.value return? A number or text?


--

John

johnf202 at hotmail dot com


"Jeff" wrote in message
...
File Structu

H:\
GO
Finance
Function_Labor
MKTG
JUN
MKTG_GROUP.XLS
JUL
MKTG_GROUP.XLS
AUG
MKTG_GROUP.XLS


VBA Code:

Sub MKTGRPsumm()
ChDrive "H"
ChDir "H:\GO\FINANCE\FUNCTION_LABOR\MKTG\" &
Months.Value
Workbooks.Open Filename:="MKTG_GROUP.XLS",
Password:="MKT2646"
End Sub ''


Scenario:

Combobox(Months) with a list of months. User selects
month in combo box then clicks on button tied to macro
above. The object is to have the user select the month of
the report to open.

Error:

Receive the following error when executing the macro:

Run-time error '424'
Object Required


Can anyone help fix this code? Thanks