Excel Macro Mania
Excel Macro Mania
  • 156
  • 1 022 536
Excel VBA Functions: ARRAY, FILTER, JOIN
See the full list of VBA functions here: excelmacroclass.blogspot.com/p/vba-functions.html
Welcome to Excel VBA Functions Series. In this video we see the array functions ARRAY, FILTER, and JOIN, used to create an array, filter the values in the array, and join values from an array, respectively. We see several practical examples of the functions in detail. Furthermore, we see a useful line of code to convert a range into a string using the JOIN function.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)
Переглядів: 583

Відео

Get Last Column With Data Excel VBA Macro
Переглядів 2722 місяці тому
Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: excelmacroclass.blogspot.com/p/excel-vba-objects-guide.html In this video we see how to get the last column with data in Excel using VBA macros. There are several ways to do it and here we see two or three different methods. The video also explains the limitations and situations where we need to be cautious...
Get Last Row with Data Excel VBA Macro
Переглядів 4023 місяці тому
Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: excelmacroclass.blogspot.com/p/excel-vba-objects-guide.html In this video we see how to get the last row with data in Excel using VBA macros. There are several ways to do it and here we see two or three different methods. The video also explains the limitations and situations where we need to be cautious to...
Send Meet Invites From Excel (via Outlook)
Переглядів 6933 місяці тому
Excel macro/VBA code available in this post: excelmacrobusiness.blogspot.com/2024/02/excel-email-management.html We can integrate Excel with other Microsoft Office applications using VBA. In this video we see how to send meet invites from Excel and via Outlook using VBA macros. The macro automatically creates an appointment item and defines the properties to create a meet invite in the recipien...
Excel VBA Functions: SPLIT, LBOUND, UBOUND
Переглядів 4704 місяці тому
See the full list of VBA functions here: excelmacroclass.blogspot.com/p/vba-functions.html Welcome to Excel VBA Functions Series. In this video we see the array functions SPLIT, LBOUND, and UBOUND, used to split a string by a delimiter to create an array of elements with a lower and upper bound. We see several practical examples of the functions in detailed. Furthermore, we see a one line of co...
Conditional Formatting Based On Another Cell Excel VBA Macro
Переглядів 1,3 тис.4 місяці тому
Conditional Formatting Based On Another Cell Excel VBA Macro
Sort Values In Range Excel VBA Macro
Переглядів 3735 місяців тому
Sort Values In Range Excel VBA Macro
Extract Emails In Excel (From Outlook)
Переглядів 3,6 тис.5 місяців тому
Extract Emails In Excel (From Outlook)
Excel VBA Functions: REPLACE
Переглядів 4796 місяців тому
Excel VBA Functions: REPLACE
Clear Cells Based On Value Using Loop Excel VBA Macro
Переглядів 8316 місяців тому
Clear Cells Based On Value Using Loop Excel VBA Macro
Clear Cells Based On Value Using Replace Excel VBA Macro
Переглядів 7417 місяців тому
Clear Cells Based On Value Using Replace Excel VBA Macro
Send Google Mail From Excel - 3 Different Options
Переглядів 5 тис.7 місяців тому
Send Google Mail From Excel - 3 Different Options
Excel VBA Functions: INSTR
Переглядів 4088 місяців тому
Excel VBA Functions: INSTR
Add Slicers To Table Excel VBA Macro
Переглядів 1,4 тис.8 місяців тому
Add Slicers To Table Excel VBA Macro
Import RESTRICTED data from Google Sheets Part 2/2
Переглядів 5239 місяців тому
Import RESTRICTED data from Google Sheets Part 2/2
Import RESTRICTED data from Google Sheets in Excel Part 1/2
Переглядів 1,5 тис.9 місяців тому
Import RESTRICTED data from Google Sheets in Excel Part 1/2
Excel VBA Functions: LEFT, MID, RIGHT, LEN
Переглядів 1 тис.10 місяців тому
Excel VBA Functions: LEFT, MID, RIGHT, LEN
Add Sheet With Name Excel VBA Macro
Переглядів 2,8 тис.10 місяців тому
Add Sheet With Name Excel VBA Macro
Maze in Excel with Kruskal's Algorithm
Переглядів 1,1 тис.11 місяців тому
Maze in Excel with Kruskal's Algorithm
Add Conditional Formatting To Unique Values Excel VBA Macro
Переглядів 1,9 тис.11 місяців тому
Add Conditional Formatting To Unique Values Excel VBA Macro
Excel VBA Functions: Excel Functions vs VBA Functions
Переглядів 548Рік тому
Excel VBA Functions: Excel Functions vs VBA Functions
5 Methods To Get Data From Google Sheets with Excel VBA
Переглядів 5 тис.Рік тому
5 Methods To Get Data From Google Sheets with Excel VBA
Convert Range To HTML Table Excel VBA Macro
Переглядів 3 тис.Рік тому
Convert Range To HTML Table Excel VBA Macro
Insert All Pictures In Folder Excel VBA Macro
Переглядів 5 тис.Рік тому
Insert All Pictures In Folder Excel VBA Macro
Excel VBA Objects: Chart Object (Part 2)
Переглядів 1,2 тис.Рік тому
Excel VBA Objects: Chart Object (Part 2)
Create Custom Functions in Excel (User Defined Functions)
Переглядів 7 тис.Рік тому
Create Custom Functions in Excel (User Defined Functions)
Compare Everything in Excel Part 3: Datasets
Переглядів 1,5 тис.Рік тому
Compare Everything in Excel Part 3: Datasets
Export Table To Word Excel VBA Macro
Переглядів 3,6 тис.Рік тому
Export Table To Word Excel VBA Macro
Customize Excel Ribbon - All You Need To Know
Переглядів 6 тис.Рік тому
Customize Excel Ribbon - All You Need To Know
Send Multiple Emails From Excel
Переглядів 81 тис.Рік тому
Send Multiple Emails From Excel

КОМЕНТАРІ

  • @MuhammadKhanzullahMuhammad
    @MuhammadKhanzullahMuhammad 4 дні тому

    Sir, I want to receive sales activities in Excel to my email address. So pls how to connect?

  • @qasimawan3569
    @qasimawan3569 4 дні тому

    Fantastic video, thanks a lot man!

  • @mohamedeid4090
    @mohamedeid4090 5 днів тому

    I tried this solution but i think i got restrict. This message appear " This message couldn't be delivered because the sending email address was not recognized as a valid sender"

  • @jelenarakic5895
    @jelenarakic5895 6 днів тому

    I thought it would take me 10h to learn how to automate a manual task that takes 15 minutes. You saved me!

  • @Hank-z8v
    @Hank-z8v 12 днів тому

    Is it possible to create the same except having a range for the body information? or would there be a copy and paste function?

  • @jmsantos1972
    @jmsantos1972 12 днів тому

    Hi. I need to import the last 5 rows in a Table... Can this be done through this method? Thanks a lot 😊

  • @tristancills6442
    @tristancills6442 13 днів тому

    THANKS!! Very helpful. You have secured my continued employment for the foreseeable future 😄

  • @ersingungor6101
    @ersingungor6101 14 днів тому

    great tutorial sir..

  • @ajazkhan55577
    @ajazkhan55577 15 днів тому

    There is a missing in tool reference Microsoft Outlook 16.0 in VBA. How to add an alternative or name change of it. How to do? I want to do it through coding and send messages from Outlook.

  • @gautamwanjari2526
    @gautamwanjari2526 24 дні тому

    Many Thanks Excel Macro mania, Its worked :-)

  • @sohandas8342
    @sohandas8342 25 днів тому

    Love u bro

  • @gabrielerickrasmana7563
    @gabrielerickrasmana7563 25 днів тому

    Is it possible if the signature using currently email signature that has been set, because the signature has a picture and gif inside? And, How to do that? Kindly need your tips Thank you

  • @PierreFOREST-w5v
    @PierreFOREST-w5v 29 днів тому

    Thanks! The new macro works great. But how do you keep the original proportions of the image?

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi2255 Місяць тому

    great idea, what about if i want to send an excel attachment too?

  • @ranim.g3514
    @ranim.g3514 Місяць тому

    I want to send 40 emails in one go to carrier's need help

  • @altafmehrab
    @altafmehrab Місяць тому

    Sorry to say that this channel is so hidden

  • @altafmehrab
    @altafmehrab Місяць тому

    The best tutor on Earth

  • @Kacih46d
    @Kacih46d Місяць тому

    @ExcelMacroMania, thanks for this lesson. I am new to macros. I ran the code as you have it and nothing happened. Would you be able to lend some assistance?

  • @loveloveonly6964
    @loveloveonly6964 Місяць тому

    Can tell me how to edit this data

  • @furiouspenguin1448
    @furiouspenguin1448 Місяць тому

    Does this also work on gmail?

  • @LeeTiclavilcaGutierrez
    @LeeTiclavilcaGutierrez Місяць тому

    Muchas gracias, me funciona con la cuenta personal de google, sin embargo, cuando lo uso con el correo de empresa no funciona.

  • @ahmetcankaplan3863
    @ahmetcankaplan3863 Місяць тому

    What Should we do if we don't Attach an attachments to every Mail ? .Attachments.Add Range("G" & r).Value If Not attach <> "" Then .Attachments.Add (attach) End If

  • @prabhasarts3737
    @prabhasarts3737 Місяць тому

    How you have created sent button

  • @xaist6085
    @xaist6085 Місяць тому

    Thank you, helped so much today. Was it possible to grab images from a subfolder in the folder we selected?

  • @chrisk.2957
    @chrisk.2957 Місяць тому

    Very good video, thanks a lot!!!!!

  • @geronimoyerena885
    @geronimoyerena885 Місяць тому

    Very good. How could the Unicode codes in the response be replaced by the original character or letter they represent? For example, the university's name is "Göteborg University" but in the response the university's name is "G\u00f6teborg University". What can be done to show "Göteborg University" (for example) in column "A". Is there a function or way to replace all the Unicode codes in the response and show the real names of the universities in column A?

  • @Rizki-vz6hw
    @Rizki-vz6hw Місяць тому

    If i used it for zimbra mail, can it work?

  • @virtualcow44
    @virtualcow44 Місяць тому

    i have issue where when i clicked button Start game, my arrows do jackshit. please help

  • @nickscott1772
    @nickscott1772 Місяць тому

    Brilliant stuff. Thanks so much! keep up the good work!!

  • @palladiumlab
    @palladiumlab Місяць тому

    Hi very helpfull thanks> how to add pictures 'in' cell instead of 'over' the cell? also how to just get the name of the file without the extension thanks in advance.

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      You cannot get "in" cell because pictures are shapes that are always over the elements of the worksheet. However, the video explains how to fit the picture within the cell borders.

  • @palladiumlab
    @palladiumlab Місяць тому

    very nice. how do we make all pictures which we have uploaded 'in' cell instead of 'over' cell. also how to just get name of the image without the extension . Thanks in advance

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      I already replied to this question above.

  • @NguyenQuan-se2ni
    @NguyenQuan-se2ni Місяць тому

    cái con quảng cáo này xấu quá

  • @deveshkrishnabissa4529
    @deveshkrishnabissa4529 Місяць тому

    great & useful video but when i click run its showing old outlook & asking me to add account , i am now using new version of the same , can you please help me get out of this

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      It does not work with online version, maybe that's why.

    • @deveshkrishnabissa4529
      @deveshkrishnabissa4529 Місяць тому

      Thanks for your reply I am using new version and I also have subscription of the same can you help me when I click on send mail its showings add account but it's not working

  • @dsd8087
    @dsd8087 Місяць тому

    How to copy also the formula to new sheets?

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      Sheet1.Range("A1").Copy Sheet2.Range("A1").PasteSpecial xlPasteFormulas

    • @dsd8087
      @dsd8087 Місяць тому

      @@ExcelMacroMania thank you so much!

  • @davidcarr7793
    @davidcarr7793 Місяць тому

    You are not converting it. You are building it from the data. I was hoping for a direct conversion so it would pick up cell formatting.

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      This converts the range data into HTML, I give some examples of its application in the beginning of the video. If you want to create a web table with the same formatting of an Excel table, you need a much bigger macro that will read each of the formatting properties and translate into HTML/CSS.

  • @maliktaha95
    @maliktaha95 Місяць тому

    It says compile error user defined type not identified. Kidnly help

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      I believe you are mistyping some variable or function. Check the correct code here: excelmacroclass.blogspot.com/2023/05/send-multiple-emails-from-excel-vba.html

    • @maliktaha95
      @maliktaha95 Місяць тому

      @@ExcelMacroMania Thankyou the code is working, however can you tell how can I use it through outlook web instead of application because my administrator only has allowed my outlook account to be used through the web. Kindly Help

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      @@maliktaha95 Unfortunately this does not work with the web version of Outlook.

  • @profoundveda3584
    @profoundveda3584 Місяць тому

    How to import data from restricted google sheet without access

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      You cannot import data if you don't have access to the restricted google spreadsheet.

  • @neejudeshwal6515
    @neejudeshwal6515 2 місяці тому

    good

  • @mehulalondara8516
    @mehulalondara8516 2 місяці тому

    this macro will delete only if blank cell in column A, but ideally it should delete only if entire row is blank.

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      Simply change the condition to match your criteria. If you want to delete when the entire row is empty you can do something like this: If WorksheetFunction.CountA(Rows(r)) = 0 Then ...

  • @marievicibayan54
    @marievicibayan54 2 місяці тому

    Hi hope you see my message. how to add an attachment to Gmail using a hard-coded path/file name in VBA?

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      CDOmail.Attachment "c:\data\testmail.xlsx"

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      Check the code here: excelmacroclass.blogspot.com/2024/01/send-google-mail-from-excel-vba-macro.html That line should go inside the With block for CDOmail. With CDOmail .... .Attachment "c:\data\testmail.xlsx" .Send End With

  • @SarnathR-m5u
    @SarnathR-m5u 2 місяці тому

    Hi, i cannot get size for a folder with a size more than 1GB. I am not even able to use msgbox command for this. Any idea why?

    • @SarnathR-m5u
      @SarnathR-m5u 2 місяці тому

      These are one drive files in my laptop

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      @@SarnathR-m5u I think the problem is not with the size of the folder (I've got it working for folder size over 1 GB), it is rather with the fact that is one drive files.

  • @dragoesdeolivenca
    @dragoesdeolivenca 2 місяці тому

    I get this error: Compile error: User-defined type not defined How to fix?

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      You've probably mistyped some variable or object. Please check and use the correct VBA code here: excelmacroclass.blogspot.com/2022/09/upload-data-to-google-sheets-excel-vba.html

  • @nadermounir8228
    @nadermounir8228 2 місяці тому

    Very nice Video :)

  • @paulsteel8739
    @paulsteel8739 2 місяці тому

    No Option Explicit? 😞

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      Sure, feel free to use Option Explicit, specially for longer macros or big VBA projects with lots of variables. I do not use it in my videos as macros are short with few or no variables, and do not want to confuse the audience. I talk about Option Explicit in tutorial for beginners here: ua-cam.com/video/YMjbuA2g8AQ/v-deo.htmlsi=BhbCaft0Vqnzdk0D

  • @ivansosa8439
    @ivansosa8439 2 місяці тому

    Excellent. Yet, I need to copy all filtetered data just on one sheet , which goes one bellow the other other as per brand (following thus your example)

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      Check this other video, it might help you: ua-cam.com/video/jyHcAOqkRZE/v-deo.htmlsi=9OpdQJOnFkVigtxy

  • @Micomicooo-eo5ee
    @Micomicooo-eo5ee 2 місяці тому

    How can I make part of the text bold?

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      Use HTMLBody along html code for example as follows: OutMail.HTMLBody = "<html><b>Text in bold</b></html>"

  • @UsmanAli-fs3jo
    @UsmanAli-fs3jo 2 місяці тому

    Hi, I just want to know is it possible to send multiple email with different attachment to multiple recipients?

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      Of course it is. Add the location to each attachment in each row (in column F in this example) and then refer to that cell while looping through rows as you target each individual email or subject, for example as shown below: OutMail.Attachments.Add Range("F" & r).Value

  • @nayanjeetsinghdhadwal6142
    @nayanjeetsinghdhadwal6142 2 місяці тому

    Hi, It is not working for me, please help.

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      Make sure you have Outlook configured, add the Outlook library to Excel VBA project references, and the code is correct - check the code here: excelmacroclass.blogspot.com/2023/05/send-multiple-emails-from-excel-vba.html

    • @nayanjeetsinghdhadwal6142
      @nayanjeetsinghdhadwal6142 2 місяці тому

      @@ExcelMacroMania it worked, but I want to know if I use @CC it will allow me to add email addresses to CC of that email, correct? and how can I edit the fonts of the body of the email....

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      @@nayanjeetsinghdhadwal6142 Glad it worked. OutMail.CC will add the emails as carbon copy, yes. To update the font use HTMLBody along html with a given font or using CSS.

    • @nayanjeetsinghdhadwal6142
      @nayanjeetsinghdhadwal6142 Місяць тому

      @@ExcelMacroMania didn’t understand any thing about the HTML and css, like you mentioned the body of the email in a column, how can we change the font or background colour of the text or change it into bold italic underline ?

    • @ExcelMacroMania
      @ExcelMacroMania Місяць тому

      @@nayanjeetsinghdhadwal6142 You need to learn the basics of HTML and CSS, please check online. Then you use HTMLbody to format the email body as you wish. For example, if you want to change the font size of a paragraph in the email you could do something like this: OutMail.HTMLbody = "<html><p style="font-size:30px">This is a bigger paragraph.</p></html>"

  • @ankitasonwane5333
    @ankitasonwane5333 2 місяці тому

    Awesome

  • @imocha1049
    @imocha1049 2 місяці тому

    Thanks a bunch for this video. But I'm sad as the method in this video does not support Windows 11 and Microsoft 365 users. My VBA workbooks have so many custom ribbons. Even without the micro-enabled file, those customized ribbons still appear. I'm struggling to find a way to make the custom ribbon only appear in a specific workbook. Sir, do you have any idea? Thank you.

    • @ExcelMacroMania
      @ExcelMacroMania 2 місяці тому

      I don't know why it doesn't work for you because I've also done this with Win11 and M365 and it works. Maybe security policies from your company? You can raise it with your IT department.