D
Darin Kramer
Hi There,
Ive got VB that opens a workbook, runs a macro on it and closes the
workbook.
Currently the VB refers to a specific location.
I would like for the user to select from a drop down within the current
book the locaton onto which the VB should run, ie take data entered into
a sheet and transfer it into VB.
An extract of the current VB is
sName = Dir("\\server1\Area1\*.xls")
Do While sName <> ""
Set bk = Workbooks.Open("\\server1\Area1\" & sName)
Call Macro 1
So basically I want the user to be able to change Area1 to Area2 etc..
Is this possible..??
Regards
D
Ive got VB that opens a workbook, runs a macro on it and closes the
workbook.
Currently the VB refers to a specific location.
I would like for the user to select from a drop down within the current
book the locaton onto which the VB should run, ie take data entered into
a sheet and transfer it into VB.
An extract of the current VB is
sName = Dir("\\server1\Area1\*.xls")
Do While sName <> ""
Set bk = Workbooks.Open("\\server1\Area1\" & sName)
Call Macro 1
So basically I want the user to be able to change Area1 to Area2 etc..
Is this possible..??
Regards
D