How to set global constants and get path of spreadsh ?

W

wellie

Global Constants:
I've VBA functions/subs attached to various
worksheets/modules in a workbook. There are some common
constants (integer/string) among them. Can someone plz
tell me how do I set these constants as global constant
s.t. I can reference the rather then redefining them in
the sheet/module that I need to use ?

Get Path of Spreadsheet:
Can someone please tell me how can I get the current full
path where the spreadsheet is using VB code ?

Thanks for any help.
 
Top