- 156
- 1 022 536
Excel Macro Mania
Приєднався 27 лис 2021
Everything's possible in Excel. Come along to learn Excel VBA and create amazing macros with me here.
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/)
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)
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
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
Customize Excel Ribbon - All You Need To Know
Переглядів 6 тис.Рік тому
Customize Excel Ribbon - All You Need To Know
Sir, I want to receive sales activities in Excel to my email address. So pls how to connect?
Fantastic video, thanks a lot man!
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"
I thought it would take me 10h to learn how to automate a manual task that takes 15 minutes. You saved me!
Is it possible to create the same except having a range for the body information? or would there be a copy and paste function?
Hi. I need to import the last 5 rows in a Table... Can this be done through this method? Thanks a lot 😊
THANKS!! Very helpful. You have secured my continued employment for the foreseeable future 😄
great tutorial sir..
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.
Many Thanks Excel Macro mania, Its worked :-)
Love u bro
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
Thanks! The new macro works great. But how do you keep the original proportions of the image?
great idea, what about if i want to send an excel attachment too?
I want to send 40 emails in one go to carrier's need help
Sorry to say that this channel is so hidden
The best tutor on Earth
@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?
Can tell me how to edit this data
Does this also work on gmail?
Muchas gracias, me funciona con la cuenta personal de google, sin embargo, cuando lo uso con el correo de empresa no funciona.
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
How you have created sent button
Thank you, helped so much today. Was it possible to grab images from a subfolder in the folder we selected?
Very good video, thanks a lot!!!!!
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?
If i used it for zimbra mail, can it work?
i have issue where when i clicked button Start game, my arrows do jackshit. please help
Brilliant stuff. Thanks so much! keep up the good work!!
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.
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.
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
I already replied to this question above.
cái con quảng cáo này xấu quá
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
It does not work with online version, maybe that's why.
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
How to copy also the formula to new sheets?
Sheet1.Range("A1").Copy Sheet2.Range("A1").PasteSpecial xlPasteFormulas
@@ExcelMacroMania thank you so much!
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.
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.
It says compile error user defined type not identified. Kidnly help
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
@@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
@@maliktaha95 Unfortunately this does not work with the web version of Outlook.
How to import data from restricted google sheet without access
You cannot import data if you don't have access to the restricted google spreadsheet.
good
this macro will delete only if blank cell in column A, but ideally it should delete only if entire row is blank.
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 ...
Hi hope you see my message. how to add an attachment to Gmail using a hard-coded path/file name in VBA?
CDOmail.Attachment "c:\data\testmail.xlsx"
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
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?
These are one drive files in my laptop
@@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.
I get this error: Compile error: User-defined type not defined How to fix?
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
Very nice Video :)
No Option Explicit? 😞
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
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)
Check this other video, it might help you: ua-cam.com/video/jyHcAOqkRZE/v-deo.htmlsi=9OpdQJOnFkVigtxy
How can I make part of the text bold?
Use HTMLBody along html code for example as follows: OutMail.HTMLBody = "<html><b>Text in bold</b></html>"
Hi, I just want to know is it possible to send multiple email with different attachment to multiple recipients?
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
Hi, It is not working for me, please help.
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
@@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....
@@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.
@@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 ?
@@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>"
Awesome
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.
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.