WorkBook Naming

[Guest]

[No message]

 

[Jack in the UK]

Hi

Thats blank that one.. please try again

Rdgs
==========
Jack

 

[brettvba]

OK what I ment was is it faster to use a
Publicconst workbook as string _ = "workbookname.xls
or is there another way???
This is to reference a workbookname through all procedures!

 

[Ivan F Moala]

On 2002-02-20 16:39, brettvba wrote:
OK what I ment was is it faster to use a
Publicconst workbook as string _ = "workbookname.xls
or is there another way???
This is to reference a workbookname through all procedures!

I don't think speed is the issue with this declaration....it is just more efficient
and better programing if you work with this
particular workbook name over a large project
to declare it once and use it many times....



Ivan