Search:

Type: Posts; User: DanteAmor; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    23
    Views
    185

    Re: Attachment Download

    To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in...
  2. Re: Extracting out specific text from within a cell

    Using a search table:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  3. Replies
    23
    Views
    185

    Re: Attachment Download

    or #16 ?
  4. Re: ***SOLVED*** Re: Populate rest of Userform based on two ComoboBox Values - SOLVED

    It is a pleasure to help you. I appreciate your kind words. Thanks for the feedback.
  5. Replies
    3
    Views
    147

    Re: Sumifs and array question

    Try this

    =SUMPRODUCT((F2:K5="Justin")*(B2:B5))
  6. Re: VBA - Copy template and create new sheets

    I made some small adjustments to your code, I hope not to confuse you, it would look like this:



    Sub SheetsFromTemplate()
    Dim wsMASTER As Worksheet, wsEMPLOY As Worksheet, NewSheet As...
  7. Replies
    2
    Views
    96

    Re: Listing Data based on Dates

    Try this array formulas

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  8. Re: Extracting text from a random string and matching to a list

    Try this array formula

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  9. Re: use next available cell in row (xltoright)

    I do not understand well.
    Do you want the next available cell of the same row or the next available cell according to the row 1?

    Try this



    Sub next_available_cell()
    Dim Cell1 As Range, f...
  10. Re: How to copy values from one workbook sheet to another, based on criterias ?

    Try the following macro, it is longer than yours, but it will certainly be faster.



    Sub transfer()
    Dim fileName As Variant, a() As Variant, b() As Variant, c As Variant, i As Long, j As Long...
  11. Re: [VBA] Copy data from Certain Cells In a Sheet with different titles, but layout is the same?

    I did not understand.
    Do you have several sheets or only 2 sheets?

    You need something like this:



    Sub test()
    With Sheets("Project Charter")
    .Range("E3").Copy...
  12. Re: use next available cell in row (xltoright)

    Try the code in post #2
  13. Re: VBA to convert tabs to PDF if selected from cells

    I'm glad to help you. Thanks for the feedback.
  14. Re: use next available cell in row (xltoright)

    Try this



    Sub next_available_cell()
    Dim Cell1 As Range, f As Range
    Application.ScreenUpdating = False
    For Each Cell1 In Sheets("sheet1").Range("A1", Sheets("sheet1").Range("A" &...
  15. Replies
    3
    Views
    103

    Re: SUMIFS and Vlookup

    Assuming your data on the "gas" sheet is like this:

    Gas
    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col...
  16. Re: Populate rest of Userform based on two ComoboBox Values

    If the combination of CustId and Order Number is unique, so use the following:



    Private Sub CommandButton1_Click()
    Dim sh As Worksheet, r As Range, f As Range, cell As String, wRow As Long...
  17. Re: VBA to convert tabs to PDF if selected from cells

    Try this

    Change data in red by your information. (Sheet with the names of the sheets, folder and name of pdf file).



    Sub convert_tabs_PDF()
    Dim sh1 As Worksheet, sh As Worksheet, c As...
  18. Replies
    3
    Views
    103

    Re: SUMIFS and Vlookup

    You can give an example of your data and what are the criteria to sum.
  19. Replies
    4
    Views
    89

    Re: Macro - Delete Visible Filtered Rows

    I'm glad to help you. Thanks for the feedback.
    :cool:
  20. Replies
    23
    Views
    185

    Re: Attachment Download

    Try this please:

    Run the macro and select the folder that contains the emails.



    Sub download_attachments()
    Dim olApp As Outlook.Application, olmail As MailItem, Att As Object
    Dim...
  21. Replies
    4
    Views
    89

    Re: Macro - Delete Visible Filtered Rows

    Try this
    I guess the headings are in row 5



    Sub Delete()
    Range("C5:T" & Range("C" & Rows.Count).End(xlUp).Row).AutoFilter Field:=1, Criteria1:="<>"
    ...
  22. Re: Unable to set PageBReak property of Range Class?

    I'm glad to help you. Thanks for the feedback.
  23. Replies
    23
    Views
    185

    Re: Attachment Download

    Hi @vmjan02,

    It is in the main inbox folder or it is in some subfolder.
    The macro works for me and for the user who requested it on the link.

    Remove this line from the macro and execute step...
  24. Replies
    3
    Views
    71

    Re: Updating a formula in excel

    A little shorter



    =IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",LOOKUP(WEEKDAY(A11,2),{1,6,7},{"Mon-Fri","Saturday","Sunday"})))
  25. Replies
    23
    Views
    185

    Re: Attachment Download

    Try this




    Code:

    Sub download_attachments()
    Dim olApp As Outlook.Application
    Dim olmail As MailItem
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4