T
Tim Childs
I have a macro that I use both at work and also at home (on two machines)
but want to test for the location within the VBA code
Please can someone suggest the easiest/quickest/most elegant(?!) method for
establishing on which machine/location a procedure is being used? I realise
it is possible to get the machine ID from VBA and this requires an API.
Alternatively, I guess I could test for the existence of a particular file
or directory? Is there any other method that is better?
Many thanks in advance, Tim
but want to test for the location within the VBA code
Please can someone suggest the easiest/quickest/most elegant(?!) method for
establishing on which machine/location a procedure is being used? I realise
it is possible to get the machine ID from VBA and this requires an API.
Alternatively, I guess I could test for the existence of a particular file
or directory? Is there any other method that is better?
Many thanks in advance, Tim