Видео

Hi, This code uses the Worksheet Code Name e.g. wsOut. If your code names don't match as per the video, the code will not run for you. I briefly mention the code name setup at the 04:29 mark. Cheers

I am not sure about OneDrive. OneDrive Personal on desktop should be fine. You can construct the Folder Path like this "C:\Users\<YourUsername>\OneDrive\<FolderPath>\", which works for me. Source -techcommunity.microsoft.com/t5/excel/excel-vba-to-refer-to-files-stored-on-onedrive-instead-of-local/m-p/3894487 But, if you don't have the desktop version, I think it becomes the same as SharePoint and iterating over folders may not be possible. Haven't worked with it to be sure.

Hi, Sorry. Not yet.

@@SkillsandAutomation Sir I am requesting you to make video on excel vba class module real world projects if possible. It will really helpful for us.

Hi, Best (stable) options would be to paste as picture (ppPasteEnhancedMetafile, as in the video) or linked chart (ppPasteShape). But, if you want to paste as a Powerpoint chart or an unlinked chart, i will suggest you look into the "DataType:=ppPasteOLEObject" option. i haven't worked with this option before. i replaced it into the code for the video, it worked. Looks like copies of the original data are getting embedded into each powerpoint chart object, independent of the excel chart. maybe you can experiment further.

Hi, On Error Resume Next - Skips to the next line of code when an error occurs, while On Error GoTo 0 - Resets the Error Handler. Normally, you would use Resume Next, before the Line/ Lines you want to skip/ignore and GoTo 0 after the point from where you can want to resume normal error handling. As for a separate video, unfortunately, I won't have the bandwidth for it right now. Next, i am making a detailed vba master class series (beginner to pro) starting from mid - April onwards on RUclips. Error Handling will be covered in that, so don't want to release anything else before.

@@SkillsandAutomation thank you sir, I will be waiting for your series

Hello Sir, Have you posted any real world project 's video on Excel VBA class module?

Hi, Do you mean creating dependent dropdown lists? Short answer, Yes. If that is all you want, you could achieve it using activeX combo boxes and populate the next combo box, based on change event of the first. If you wanted to achieve it without combo boxes, you could dynamically populate the second data validation list each time Range.Validation.Add xlValidateList, Formula1:=sComments -> where sComments is string of comma separated filtered values based on the selected value in previous list, and tie this macro to an event or button trigger.

@@SkillsandAutomation Brilliant thanks, I think dynamically populate a second data validation list sounds good. I'll try and figure out how to do that. thanks

Hi, Named table is definitely, one way to do it. But, I would say, it would apply when you are in control of the Input data source. However, dynamic arrays would have a more generic use-case. e.g. suppose you are picking up data from a csv file. or, from a excel file coming from a third party source, which doesn't have a table in it. Also, using tables would be a design choice e.g. do we want to maintain 100% logic within our VBA code, or do we want to share the logic with other Excel elements such as tables, formulas? what is the estimated size of data? is our data connected to another data sourcce such as SQL table? etc. Besides that, VBA is notorious for having alternative solutions to the same problem/ task. Hence, in my videos, I will tend to try and accomplish every task using the topic for the video i.e. in this case, dynamic array. Cheers

Hi. Yes. These are properties of the email object e.g. you can use oMail.SenderEmailAddress and oMail.ReceivedTime. There are heaps more properties available. You can check out the Microsoft Learn page for what's available. I will put the link in the description.

@@SkillsandAutomation Hi, I am new to the VBA automation. I am working on a similar project where I need to add the sender Name, received time of email etc. along with the above attachments. Can you please help me with the code as to where should I add the code for sender Name, received time of email. Thanking you in advance. regards BG.

@@biplabgupta374 Hi, I have added code to output sender Name, received time of email and count of attachments onto a worksheet. You can check it out on the blogpost for a similar video i have made skillsandautomation.com/useful-code/download-multiple-attachments-from-outlook/. Scroll down to the heading: Code to Output Details of Email and Save Attachments. Hope that helps.

Hi, Thanks for your comment. No paid course. But, I will be releasing a detailed zero to hero VBA series on RUclips starting April 2024. Please check it out if it interests you.

Hi, Do you mean you want to dynamically search for the starting header row? i.e. could be any row 2,3 etc.? i would suggest using the find method. i have a separate video that shows how to dynamically identify any dataset no matter where its placed in the sheet. code can be found here: skillsandautomation.com/how-to/how-to-find-last-row-in-excel-vba-using-find-method/#Example_1_Identify_and_Select_Data_Range

i am working on that in parallel. all going well, i will start releasing it in first week of april 24.

sir ji bahut acha laga app suru karne ja rhe hai.intzar rahega.have a great day

Hi, If you want to attach a macro to a button, you would need to add a Form Control Button (Excel Ribbon -> Developer -> Insert -> Form Controls -> Button). I have a video explaining how to add a macro to a button. ruclips.net/video/iysBh7BLQXo/видео.html

sure, will take note of that. thanks

Thanks for your comment. Both Error Handling and Sub/ Functions are on my list of videos to make. I will try and release them within this month.

@@SkillsandAutomation Hello Sir, Eagerly waiting for video on Error Handling and sub/functions

Hi, It will be the next one. Will release it by this weekend.

@@SkillsandAutomation Hello Sir, I hope you are well and healthy, sir waiting for your video on error handlers and sub processure where we use parameters in child sub to call parent sub. also on creating functions as well. Sir please explain all these topics with more clarity.

Hi, working on it now. turned out longer than i expected, hence the delay. will release tomorrow.

Hi there, I didn't quite follow this question. Could you please provide more context? e.g. are you referring to something I have mentioned in this video or else are you checking regarding a different topic. Please elaborate. Thanks

Hi, Thanks. I have uploaded the file to Github now. Link is in the description of this video. Cheers, Ash

Hi, Thanks. File can be downloaded from Github. Link is in the description of this video. Cheers, Ash

@@SkillsandAutomation Thank you so much for your support. You are amazing trainer. I am requesting you to make a real scenerio project on Excel VBA where we configure a sheet to get value for whole automation rather than hardcoded so we can change value as per requirement from sheet not in coding.

That's a good suggestion. I will work on it. Gimme a couple of weeks. Cheers

@@SkillsandAutomation I am eagerly waiting for this project. Thank you so much.

Hi there, I tried the link and it was working for me. I have now, created a blog page with step-by-step instructions on how to download my macro files from Github. The link for this page has been added to the description of this video, just below the Github link. Hope that helps. Cheers, Ash