Can a workbook variable be set by clicking the workbook?

[Kobayashi]

Okay, thanks. Here goes:

There will be a daily workbook that I would like to add validation to
by code. However, the workbook will be reproduced everyday so I wil
not be able to store the validation code (that I've already created) i
it. Therefore, I have created another workbook to contain the code an
the values I would like to use for validation.
Now, I don't want to create a menu item to run the code but want to ru
the code from the values/code book. However, because the 'daily' boo
will have a very different name each day I'm finding it hard to pas
it's name to a variable in order to select/activate the 'daily
workbook and run the code? I thought that there might be a way to ru
the code from the values/code book with some kind of parameter tha
will prompt the user to select the 'daily' book; ideally by selectin
from the taskbar or, perhaps, by selecting from a drop-down list o
open workbooks?

Hope this makes more sense?

Many thanks,

Adria

 

[Bob Phillips]

Adrian,

why not give a file browser to allow the user to select. Using
GetOpenFilename (see help) you browse and the method passes the full file
name back., You can the open that workbook using the value.