Please find the attached file with solution
In case of any problem please let me know
On Dec 31, 2015 4:05 PM, "Rajeev Kumar" wrote:
> ANY UPDATE PLEASE!!!
> -- Forwarded message --
> From: Rajeev Kumar
> Date: Thu, Dec 31, 2015 at 9:09 AM
> Subject: $$Excel-Macros$$ Extract repo
"Existing macro on certain Date"
Can you please elaborate above line with some live example. Share some
files with the same
On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote:
> Hi Expert,
>
> Can i get a macro which can remove all existing macros from a file on
> certain date..
>
> Kindly share the
If you want to delete the module then use below code
'Author #Jayaraju Metta
Sub vbcomponents()
Dim vbcom as Object
Set vbcom=application.VBE.activeVBProject.Vbcomponents
vbcom.remove Vbcomponent:=_
vbcom.item("Module1")
End sub
If you find any difficulties please let me know
On Dec 23, 2015 7:45
Hello Pravin Gunjal,
Do you want to delete modules in a project using a macro?
Can you please elaborate it ?
On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote:
> Hi Expert,
>
> Can i get a macro which can remove all existing macros from a file on
> certain date..
>
> Kindly share the same. Thanks.
>
Hello,
Here is the solution
*Assumptions*
*First row is column heading*
*and second row date value is correct*
Sub BhavaniMacro()
'Written by Jayaraj.metta@ gmaill.com
Dim iDate As Date
Dim Lastrow As Long
Dim iRow As Long
Dim ImputeDates As String
Lastrow = ThisWorkbook.Act
Hi Mike,
Below is the code to find string and paste it into desired cell.
Please find the attached excel file.
'Code was written by Jayaraju Metta
Sub matchsting()
i = 1
While (ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value <> "")
ColoumnAstring = Left(Trim(Sheets("Sheet1").Cells(i, 1).Value), 5
Need to be change the file name and path when he executive on his machine
On 17 Jul 2015 14:15, "Mandeep Baluja" wrote:
> Where is the error I am not getting the same in this sheet !!, Kindly
> provide the snapshot.
>
> On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote:
>>
>
*Re: $$Excel-Macros$$ how to seperate*
> *jayaraj metta * to: excel-macros
> 13-06-15 05:26 PM
>
>Sent by: *excel-macros@googlegroups.com
> * Cc: kumar.bhanushali
>
>
>From: jayaraj metta
>To: excel-macros@googlegroups.comCc:
> kumar.bhanush...@pmc
Hi Kumar,
You can use below vba code to get contractor details simply by
entering Contractor Unique No and the filtered details will be saved
to respected contractor sheets.
Sub AutofilterExample()
Dim Criteria As Integer
'Enter "Contractor Unique No" to get respected contractor details
C
