Gustaf,

Of course, the code that you would need depends on where you are saving the data the needs to
accessed, but usually values are stored in cells:

Dim myB As Workbook
Dim myS As Worksheet
Dim myV As String

Set myB = Workbooks("CodeFile.xls")
Set myS = myB.Sheets("Storage Values")
myV = myS.Range("A1").Value


HTH,
Bernie
MS Excel MVP


"Gustaf" wrote in message ...
I've inherited a pretty extensive VBA app in Excel 2003. It uses a "router" workbook to open
alternative versions of a workbook containing the code. Now there's a need to add a custom Help
menu, and the links/paths used in that menu should be sent from the router workbook, while the
menus themselves are constructed in the code workbook. The router file creates a Workbook object
of the code file, but I haven't figured out a way to use that to transfer the data. Any ideas?

Gustaf