choubix
06-10-2008, 10:02 PM
hello,
I have a workbook that is going to dig up data from other workbooks.
is it possible to set these workbooks (data source) as constants so I don't have to change every single line where their name appears in case we need to change their name??
I tried somehting like this:
Public Const input = "myworkbook1.xls"
and then tried to call:
workbooks("input").activate
it didnt work.
my idea is to set all the workbooks I need to use as constant and to call them like this:
input.activate
input1.activate etcetc
any idea please??
I have a workbook that is going to dig up data from other workbooks.
is it possible to set these workbooks (data source) as constants so I don't have to change every single line where their name appears in case we need to change their name??
I tried somehting like this:
Public Const input = "myworkbook1.xls"
and then tried to call:
workbooks("input").activate
it didnt work.
my idea is to set all the workbooks I need to use as constant and to call them like this:
input.activate
input1.activate etcetc
any idea please??