Thread
:
How to set global constants and get path of spreadsh ?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
How to set global constants and get path of spreadsh ?
Wellie,
1) Declare the constants as Public variables in a standard code
module. E.g.,
Public Const cMyConstant = 1234
2) Use the FullName property. E.g.,
MsgBox ThisWorkbook.FullName
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"wellie" wrote in message
...
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.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson