Recent content by dev.sutradhar1987

I have a macro which creates a outlook mail from an excel database. What i am thinking is to embed a command button in the mail body with a macro to reply to the mail using specific email ids written in the macro so when ever it sent to a user and if he wants to reply to that mail then he just...

Hi, I am trying to find mails with the relevant Subject from the outlook and then "replytoall" with a given format in the Body. I have used the following code for searching the mails. Sub Test() Dim olApp As Outlook.Application Dim olNs As Namespace Dim Fldr As MAPIFolder...

Hi All, I Hsve created a code with a loop Sub CountPaste() Dim i, cnt As Integer Dim wb As Workbooks On Error GoTo ErrHandler: 'This Code has been created by Dev Sutradhar 'Workbooks.Open ("D:UsersdsutradhDesktopConfidentialNew folderMaster File_23072013.xlsx") 'Workbooks.Open...

Hey Smallman its Done i have done it. Thanks for your help and the concept.

Hi Smallman, It is not working. Could you please help me in creating the complete macro.Please

Hi, I have a Sheets "Template" where i enter id's and then press a Button "Create" which creates a new sheet with the Name from Range("F4") of the Template Sheet. Then it gets copied to Sheet("Index") and is pated in coloum "B" in the next empty cell. I have done this far. Now i need to get...

Hello Smallman, The code is working fine and you gave me exactly what i needed. Thank you so much for your help and time . Cheers :)

Hi Hui, I looked at it and understood it but my problem is i need a to get the data with a Date Range. Suppose i enter FromDate - 15.07.2013 & ToDate - 19.07.2013. I want all the data within that date range to be populated. With a particular "Text" i can also get the data populated using...

Hi Shrivallabha, Sorry i couldnot reply earlier as i was on vacation. Teh code works great. I have modified it bit to suit my needs. Thanks A ton for your Time and Help..Cheers :)

I have a Sheet where the Dates are in Column "C" of sheet "Collated".I am trying to extract a Report on a Different Sheet named "Process View" where if i give in the date Range it will find the date in the "Collated" Sheet and copy the netire row and paste it in Sheet "Process View"for range...

Hi, I have looked and searched for previous posts not getting what i want. I have a Sheet in a Workbook name "Weekly Report". I want a macro which when clicked will export the sheet with name " Weekly Report Week" Sheet("Weekly Report").Range("Q1").Value to my desktop. The path as far as i...

Hi vijay, Thank you so so much. Yes absolutely you have helped me a lot. Cheers :)

Hi Vijay, I have send the File to your given Id. Please check and help me out.

Hi All, I have a File which i had created long back and now i need it's macro part to do a new job.But the problem is that I have locked the VBA Project and now forgot the password. I have checked the previous posts and tried the HEX editor but no result.I have uploaded the file and provided...

Thanks. Today i learnt something new. thanks a lot for explaining the thing. Cheers :)