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

*** Sent via Developersdex http://www.developersdex.com ***