in my module i want to have variable with connection parameters

for example i want to once describe this variable somewhere in module

cons = "provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=db.mdb;"


and after that i simply want to use this string variable in each sub


maybe i must to use constants

--
Message posted from http://www.ExcelForum.com