• 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.

Recent content by VARGEESH

  1. V

    Help on Questionnaire in Excel using VBA

    Hello! Please advise me on the below scenario. Plan: I would like to prepare a questionnaire in Excel using VBA, One question for one sheet, probably 20 sheets will be there. When the user start the test, a timer will be running on "A1", if the time value > 60(1 Minute) then it will go to the...
  2. V

    Copy email id from attachment

    Hi could you please give your sugesstion.
  3. V

    Copy email id from attachment

    Colud you please advise me.
  4. V

    Copy email id from attachment

    The email template link: http://db.tt/qY7vuFk4 Sample attachment link: http://db.tt/vGuA67Rq
  5. V

    Copy email id from attachment

    Hi All, I have an email template that i got at Chandoo.org. It is working very well. Thanks for all your support of all Chandoo's:). And i need a help on that. When i attach some files it gets the path of the file name and the same has been attached while sending the email. The attached...
  6. V

    Get Username in MsgBox

    Hi Dhamo, Yes it's working fine. Thank you Dhamo. Regards, Vargeesh
  7. V

    Get Username in MsgBox

    Hi, I used the below code to display the current username while opening the workbook. Private Sub Workbook_open() MsgBox "Hello " & Environ("Username") & "!", vbInformation, "Welcome Note" End Sub It's working fine. But it gets the userid instead of...
  8. V

    Get file path by selecting folder

    Of course Deb. I will do google search. Thanks for your advice. The code is: http://www.2shared.com/document/KDM-RKuk/Fiepath.html
  9. V

    Disable Outlook 2010 e-mail security prompt

    Yes Deb, I found just before.. Here is the code. http://www.2shared.com/document/KDM-RKuk/Fiepath.html Thanks for you..
  10. V

    Disable Outlook 2010 e-mail security prompt

    Hi Ded, Thanks for your answer. Since I am not much aware of it I asked the question. If there is solution please let me know Thanks, Vargeesh
  11. V

    Disable Outlook 2010 e-mail security prompt

    Hi, I used to send emails from excel using outlook. When I send emails it displays a security prompt to send or not send the message. It is okay when I send up to five messages. But at the time of 100 emails for each email I need to confirm the security prompt. It will be helpful if I...
  12. V

    Get file path by selecting folder

    Hi Deb, Thanks for your suggestion. Please find the below link. http://www.2shared.com/file/j5nCijSr/FilePath.html The code you have mentioned searches a file alone. But I need to get all the file path within a selected folder irrespective of file extensions. Regards!
  13. V

    Get file path by selecting folder

    Hi Luke, When I execute the below code it thrown an error like "Run time error'445': Object dosen't support this action". And it was highlighted on Set fs = Application.FileSearch Sub ListAllFiles() Dim fs As FileSearch, ws As Worksheet, i As Long Set fs = Application.FileSearch With fs...
  14. V

    Get file path by selecting folder

    Hi, I ran the below code to get the file path. By selecting the file it retrieve the file path. Sub GetFilePath() FilePath = Application.GetOpenFilename("Excel Files (*.xls), *.xls") If FilePath <> False Then Range("F5").Value = FilePath End If End Sub But I wish to...
  15. V

    Email with attachment using VBA

    Luke it works well! To change the from address: .SentOnBehalfOfName = abc@abc.com My code is: With OutMail .SentOnBehalfOfName = cell.Offset(0, -1).Value Thank you so much for your assistance from flower to fruit. With Thanks, Vargeesh M
See more
Back
Top