• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Text to Date Format

    thanks suresh..working fine..
  2. B

    Text to Date Format

    Hi Suresh, That helps, but I want this to be used in a Macro. better if there is no manual things. Prasad
  3. B

    Text to Date Format

    Dear All, I have dates in Column "J" like 18.09.2012 21.05.2012 21-05-2012 And I want them to be changed as MM/DD/YYYY format. 09/18/2012 05/21/2012 05/12/2012 PLease help on this. Regards, Prasad
  4. B

    Issue with Used Range

    can some one pls explan in detail, as am new.. If possible please change in my existing code and post. Thanks in advance. prasad
  5. B

    problem with code

    Sub VB_Yes_No() Dim YesOrNoAnswerToMessageBox As String Dim QuestionToMessageBox As String QuestionToMessageBox = "Do you Really want to execute through Database?" YesOrNoAnswerToMessageBox = MsgBox(QuestionToMessageBox, vbYesNo, "VBA Expert or Not") If YesOrNoAnswerToMessageBox...
  6. B

    Issue with Used Range

    Dear Friends, I have the below code to create a textfile on my desktop with a used range. When I ran the below macro for the first time used range was 805, then it was 600. But still the below code is using the range as 805 only. Please suggest. Sub Create_File() Dim sFile As String Dim...
  7. B

    VBA code required

    required in code, becos want to add it in existing macro
  8. B

    VBA code required

    Dear All, I have coulmn A which has 100 accounts. Need a code to check whether any cell in this row is blank. If Blank, in Coulmn B it should update as No Account Number.
  9. B

    Connecting to Oracle

    Dear All, I have an excel sheet with 100 accounts. I need to check in the Oracle database whethere those accounts are existed in database or not. Please help me. Regards, Prasad
  10. B

    Constraints to be checked

    sorry, i dont knw this...here are the links.. http://www.2shared.com/file/Tx8h04Vm/Source_File.html http://www.2shared.com/document/q8BAUGel/Output_File.html http://www.2shared.com/file/BFio2Fb9/Template.html
  11. B

    Constraints to be checked

    I uploaded the files in 2shared.com..please help.. @SirJB7: You can call me Prasad... As am new to this site, i dont knkw how to change the display name. Prasad
  12. B

    Constraints to be checked

    how can we add the excel attachemtns..
  13. B

    Constraints to be checked

    I have 3 excel sheets. 1 is Source, 2 template and 3 is Output. Template sheet is having upload button, once i click on upload file button, it should browse and I will select the "source" file. In text Box I will Provide the Value as ex..540022MU But output file should generate after having...
  14. B

    Blank Cell

    Hi Luke, Forgot to mention, is it possible to add one more MSGBOX ("Are You Sure Want to Submit?" After all validations done. Regards, prasad
  15. B

    Blank Cell

    wow..Luke..Awesome..its working fine..Really helped alot.. Can I post one more query..??
  16. B

    Blank Cell

    wow..Thanks ton..its working..I am bashing my head since morning as am poor in VBA. One more thing, the below is the code for sending mail. In subject line, I want whatever value is there in B3 Cell to be added to Subject line. And Body Should be as below. And signature should also B3 Cell...
  17. B

    Blank Cell

    Dear All, I have a sheet and it has one Button. That Button will send the active workbook through mail. But before sending that it should check E4,E6,E7,E8,E9,E10,E12,E13,E15,E16,E17,G4,G6,G7,G8,G9,G10,G12,G13,G15,G16,G17,H4,H6,H7,H8,H9,H10,H12,H13,H15,H16,H17 whether these cells are filled...
Back
Top