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

    Extracting Date Values to Display in Chart

    I have the following Excel 2007 sheet that is updated on a daily basis with the new days data: Date Call Type Volume 19/11/2012 Damage 2 19/11/2012 Door 2 19/11/2012 Failed 2 20/11/2012 Damage 3 20/11/2012 Door 3 20/11/2012 Failed...
  2. A

    Sending an Email with VBA code that auto populates address and subject

    All working. Thanks for all your help
  3. A

    Sending an Email with VBA code that auto populates address and subject

    Hi, Apologies I hadn't copied in the start of the code. Should have read: Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _ ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _...
  4. A

    Sending an Email with VBA code that auto populates address and subject

    Hi, I've removed the apostrophe and when I run the code I get a compile error: Sub or Function not defined. Sorry to be a pain.
  5. A

    Sending an Email with VBA code that auto populates address and subject

    Hi Luke, I've pasted in the code above but when i double click on a cell in col AK a timer appears but nothing happens. Have I missed something obvious? Thanks again for your help
  6. A

    Sending an Email with VBA code that auto populates address and subject

    I have one final question... This macro runs when a user hits a button at the end of a row of data relating to an individual user request. This then emails the result of the request back to the requestor. As more requests come in they will add in the rows below Row 1 . Rather than assign...
  7. A

    Sending an Email with VBA code that auto populates address and subject

    Hi,, Thank you so much! Really really helpful.
  8. A

    Sending an Email with VBA code that auto populates address and subject

    Hi All, I am using the following piece of VBA code in Excel 2007 to automatically generate an email when a button is pushed: Sub SendEMail() Dim Email As String, Subj As String Dim Msg As String, URL As String Dim r As Integer, x As Double r = ActiveCell.Row 'Get the email address...
  9. A

    Using VBA to Auto refresh an advanced Filter

    Hi All, I was wondering if anyone can help with the following: I have set up an advanced filter in Excel 2007 to filter data from a master spreadsheet (Download) into seperate sheet (MI) The Advanced Filter details look like this: List Range: Download!$A$1:$AK$100 Criteria range...
Back
Top