Thread: VBA code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_21_] Jeff[_21_] is offline
external usenet poster
 
Posts: 4
Default VBA code

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