skip to main
|
skip to sidebar
Pages
Home
About Me
Foss
NGO
Projects
EBay
Videos
Audio
Labels
Coding
(7)
Dot Net
(3)
E Commerce
(1)
Gadget
(2)
General
(6)
Magento
(1)
Software
(2)
Technical
(23)
Blog Archive
►
2012
(1)
►
August
(1)
▼
2011
(8)
►
February
(1)
▼
January
(7)
File copy code using excel macro or VBA
To remove duplicate value in excel cols (VBA Code ...
File rename (VBA Code -Excel Macros)
To find the presence of bulk image in local path(V...
To find duplicate element in excel cols (VBA Code ...
Code to count the tag in html page (VBA Code -Exce...
To filter a column from other column (c=a-b) in ex...
►
2010
(36)
►
November
(1)
►
October
(3)
►
August
(2)
►
July
(30)
Wednesday, January 12, 2011
To find the presence of bulk image in local path(VBA Code -Excel Macros)
Const strIMAGE As String = "D"
Const newFLAG As String = "E"
Public Sub Tl_Generic()
Dim i As Integer
For i = 3 To 13
If Dir("
" \ Range(newFLAG & i).Value) <> "" Then
Range(newFLAG & i).Value = "present"
Else
Range(newFLAG & i).Value = "missing"
End If
Next i
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Catch Me On
No comments:
Post a Comment