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.
 
C

Chip Pearson

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 (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating "Blocks" of Constants 4
How to get global values 4
questions about Public Constants 3
retrieving the list of public constants of a class? and possibly their integer values? 3
saving a workbook, naming it and saving it to a specific path 2
How to get info of new filename and new path 2
Need to see the path in Word 2010 5
Auto repeate parts of functions 2

Top