Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set global constants and get path of spreadsh ?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I display a hyperlink from one spreadsheet on another spreadsh | Excel Worksheet Functions | |||
I am having some trouble with a long formula and multiple spreadsh | Excel Worksheet Functions | |||
why does the page number appear in the middle of my excel spreadsh | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I use a JPEG watermark as background in an excel spreadsh. | Excel Discussion (Misc queries) |