store variables in vba

[mcinnes01]

Hi,

I am working on a multistage excel form, and one part of the process it prints the excel sheet to word as a picture and gives you the option to print it. It then saves the word doc in a folder and closes word. The files name is variable dependant upon the date and the individual it relates to.

I need a way that I can pull up this document again in another module, I know you can set constants/variables with dim and set, but is there a way of setting these globably? if thats the word, for this project so they can be referenced in various modules?