P
Patrick Molloy
sure:
DIM sPath as String
sPath = "c:\windows\temp"
Shell sPath
DIM sPath as String
sPath = "c:\windows\temp"
Shell sPath
P
Peter T
At the top of the module
Private Const cPATH As String = "c:\windows\temp"
Public Const cNUM as Long = 123
The private constant will be visible to all procedures in the module, the
public one throughout the project.
Regards,
Peter T
Private Const cPATH As String = "c:\windows\temp"
Public Const cNUM as Long = 123
The private constant will be visible to all procedures in the module, the
public one throughout the project.
Regards,
Peter T
S
StargateFan
I have little experience scripting generally, but have a lot with
AutoIt, a freeware scripting language. One of the very cool features
is the way we can use variables to make life a whole lot easier, for
example.
;=======================
$Path = "c:\windows\temp"
;=======================
Shellexecute($Path)
The advantage of the above is that it's easy to make a script that you
just plug in the changing values at the top and then not touch the
content. This is a very simpe example, but sometimes things can get
pretty complicated and using variables in this manner really
simplifies things.
Is there a comparable system in Excel so that we can put all variables
at the top and leave the rest of the script to do the tasks?
Thanks!
D
AutoIt, a freeware scripting language. One of the very cool features
is the way we can use variables to make life a whole lot easier, for
example.
;=======================
$Path = "c:\windows\temp"
;=======================
Shellexecute($Path)
The advantage of the above is that it's easy to make a script that you
just plug in the changing values at the top and then not touch the
content. This is a very simpe example, but sometimes things can get
pretty complicated and using variables in this manner really
simplifies things.
Is there a comparable system in Excel so that we can put all variables
at the top and leave the rest of the script to do the tasks?
Thanks!
D