Can a workbook variable be set by clicking the workbook?
 

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

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27331

Can a workbook variable be set by clicking the workbook?
 

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.

--

HTH

RP

"Kobayashi" wrote in message
...

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 will
not be able to store the validation code (that I've already created) in
it. Therefore, I have created another workbook to contain the code and
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 run
the code from the values/code book. However, because the 'daily' book
will have a very different name each day I'm finding it hard to pass
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 run
the code from the values/code book with some kind of parameter that
will prompt the user to select the 'daily' book; ideally by selecting
from the taskbar or, perhaps, by selecting from a drop-down list of
open workbooks?

Hope this makes more sense?

Many thanks,

Adrian


--
Kobayashi
------------------------------------------------------------------------
Kobayashi's Profile:
http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread...hreadid=273314