Hi
Also you may be required to set myAddIn.Installed = True when condition is
met,, because once addin is disabled it wont get automatically
enabled/installed.
CHeers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Sep 23, 2014 at 10:06 AM, my excel
Sir,
i created an add-in for my excel work
but i am trying to write a condition it will only run in Computer Name=
PCEARTH
otherwise sub programs will be disabled automatically or not working
thanks
Sub CompName()
Dim tSName As String
Dim ThisComputerName As String
Hi
Use this code:
Sub CompName()
Dim ThisComputerName As String
Dim myAddIn As AddIn
If UCase(Environ(computername)) = PCEARTH Then
ActiveSheet.Range(S1).Value = INDIA
Else
MsgBox (Sorry You are Not a Authorised User)
' below sub programs must be
thanks a lot sir
On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Use this code:
Sub CompName()
Dim ThisComputerName As String
Dim myAddIn As AddIn
If UCase(Environ(computername)) = PCEARTH Then
ActiveSheet.Range(S1).Value = INDIA
Else
It working fine in this file, your formula is fully qualified your
conditions
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: Apr/Sat/2012 12:16
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition
I hope this will help You Ashish.
On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
I use date in if formula but not work in attached file, please know me the
my mistake.
Thanks regards
Ashisih Bhalara
--
FORUM RULES (986+ members already
*Can you show sample OUTPUT in another column...*
*
*
On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear sir,
I want to write the cell address to fulfill formula, is there any solution
for it?
Ashish
On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi