Referencing global values in one workbook from another
 

I am trying to reference a global constant called giTitleRows from one
workbook in another workbook

Something like:

iTitleRows = workbooks(€œWorkbook1€�).module(€œModule1€�).g iTitleRow

in a workbook that has a const definged in a module called module1

Is this possible?

Also .. how can you call a function from one workbook to another

iTemp = workbooks(€œWorkbook1€�).module(€œModule1€�).G etTotalRows

Thanks in advance,

Stewart Rogers