Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question

Quereact Latest Questions

  • 0
Anonymous
Anonymous
Asked: August 15, 2022

I have an excel files which contains many sheets. for evey sheet, the name is equal to name of student. How Sort worksheets by alphabet using vba Excel? thank you

ExcelVBA
  1. Anonymous
    Best Answer
    Anonymous

    hello, try this code it will help you: Private Sub CommandButton1_Click() Application.ScreenUpdating = False 'disable screen update for performance Dim i, j As Integer Dim SheetsCount As Integer SheetsCount = Sheets.Count For i = 1 To SheetsCount - 1 For j = i + 1 To SheetsCount If Sheets(j).NameRead more

    hello,

    try this code it will help you:
    [crayon-66f19d7bb8a5b105063673/]
     

    See less
    • 1
0
0
Be the first one react
  • 98
Anonymous
Anonymous
Asked: July 31, 2022

Hello, I have an excel file that is updated automatically from some websites. This files contains products prices. I want to send automatically  an email when the price drop under a value. Is there a way How to send email using VBA Excel?How to Send Email in Excel Using VBA? Thanks for your help

ExceloutlookVBA
  1. Anonymous
    Anonymous
    This answer was edited.

    Hello,   You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library. To activate it, go to Tools in the VBA editor > References. Activate Microsoft Outlook 16.0 Object Library :     Then in a module use this subroutine: Sub sendAnEmail(ByRefRead more

    Hello,

     

    You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library.

    To activate it, go to Tools in the VBA editor > References.

    Activate Microsoft Outlook 16.0 Object Library :

     

     

    Then in a module use this subroutine:
    [crayon-66f19d7bb9088987908140/]
     

    To test the code, call this code using a buton:
    [crayon-66f19d7bb908b765158300/]
    Test:

    I hope this will help you.

    Good luck!

    See less
    • 0
0
0
Be the first one react