• 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. 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 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...
  3. 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...
  4. 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...
  5. 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...
  6. V

    Email with attachment using VBA

    Hi, I have 200 pdf documents and the name of the documents is from 1 to 200 in a folder(Names of the docements like 1, 2 , 3, ... 200) I need to send each of the documents in 200 separate emails to the same receipient with the same message body but with the different attachment. Can you...
  7. V

    Not able to run the macro in other location

    Hi, I had created a macro file and saved on my desktop. It was working fine. After i copied the file to my hard disk and tried to run the macro. It was thrown an error message stated that [Cannot run the macro "C:UsersVargeeshDesktopFormatting_Template.xlsm'!selectfile. The macro may not...
  8. V

    Insert formula at the time of running the macro

    Hi, I am running a macro coding in an excel file. In that excel file Column "A"(Old date) has past date. Also there are three blank columns named as:- Column B = "TODAY" Column C = "AGEING" Column D = "AGEING > 7 DAYS". When i run the macro it should write the formulas In...
  9. V

    Macro to Copy and Paste the data

    Hi, I have an excel file name as "Format" in which "Sheet1" has a command button. When i click the command button it should open the Open dialog box using the below code: Application.GetOpenFilename("excel(*.xls), (*.xls)") Then I will select an excel file and it should copy the...
  10. V

    Formatting using Macro

    Hi All, I have to format a report on daily basis. For that I had recorded a macro and it works quiet good. But when i have less data or more data it wasn't working. My activities are as follows:- 1. Select the entire sheet. 2. Go to sort > sort by "Column A" 3. "Sort Warning"...
  11. V

    Assign shortcut key to a command button

    Hi, I wrote some code in a command button and it is working well. However, every time i needs to click it by using mouse. Can you please advise me how to set a shortcut key for the command button. It would be more helpful instead of using mouse. Thanks for your help in advance...
  12. V

    Data validation

    Hi, Scenario 1: When entering data in a cell it should start with "0" and should allow upto "099". if else display an error message. Scenario 2: While entering data in a cell it should start with "0" and should accept upto 5 digits alone. if else display an error message. Scenario 3: A...
  13. V

    To identify the begining number

    Hi, can you help me to find out whether the number starting with "1". if else it should throw a message like "Check it". My data will be like this: 1562 1156 1365 Kindly advice me the formula.
  14. V

    To Link an excel sheet with Formatting

    Hi, I have a student data i one sheet. I want to have the data in another sheet with formatting. Eg: The fields are: StudNo, DOB, Fees, DeptNo, etc. My linked sheet should have the following formatting:- Condition for StudNo: It should begins with "0".(In raw data it will not begins with...
  15. V

    Macro for Find All

    Hi, I need a macro code for the below. I have a workbook with more than 30 sheets. When i find something, it should find all and should export to a new workbook. And the workbook name should be the searched criteria. For instance: - My query is: "COM" The Process should be: 1...
  16. V

    To find the name

    I have a student list. the format is given below. COLUMN A COLUMN B Stud_Name Stud_No Ragul 101 Abishek 102 Guna 105 Jenifer 108 Lenin 104 While entering the student no in C1 the student name should display in D1. For that i am using...
  17. V

    concatenation with Alt + Enter

    Hi All, I am using the concat code of Chandoo to concatenate a range of cells. It's very useful for me. The result of the code is like this. Eg:- A1= APPLE A2= ORANGE A3= BANANA while executing the concat code the result will be like this. [=CONCAT(A1:A3),,)] APPLE,ORANGE,BANANA...
Back
Top