@ExcelMacroMastery Thank you for sharing your knowledge freely, and for taking viewer comments as a sign of engagement, not criticism. You're the Maestro.
Looks like the only channel on youtube who loves VBA and knoows what really needed in everyday work! That is lifesaver if you need to change something in csv without changing original format! Thanks!
Excellent information, especially the last example of writing the contents of the array to a column!! I’m so glad that I had previously subscribed to your channel, otherwise I might’ve missed this information. Thank you so much for making this available!
Fantastic as usual Mr Kelly! And very timely for me as I am up to my neck in trying to sort out a database full of portly entered and inconsistent names. This will help a lot!
Hi, I hope you’re doing well ! I have a workbook that is used by multiple users through the network and it has a macro inside but some users have macros desabled. Is there a way to enable macros among the network users ? Thanks !
2:30 I am accustomed to seeing "delimiter", not "delimeter". I do believe that "delimiter" is the correct word, but apparently it is not a reserved word in VBA.
Hi Paul, Just a small comment. It's fast and straifhtforward. I am near 100% reluctant to use it because it takes only one delimiter. With little efforts it can be built a MySplit procedure/function which can take multiple delimiters. I use complex strings concatenations based on specific delimiters to see which is which. Maybe you will make a video with a MySplit function?
1- Can the Excel add-in be programmed in another programming language such as C#, C ++ , Python or only through VBA? 2- Can we replace VBA in Excel with C#? If it is impossible, why not?
In office 365 subscription the dyanamics arrays formulas engine allows that the result can fill many cells at a time without using Ctrl + Shift + Enter. In case of working with arrays in VBA and print many results in a worksheet, it is no longer necessary to resize the range (Range.Resize method) because the Excel formula engine will do it automatically.
Very amazing video but too fast ;) I need to go back each time;P If I had more experience I wouldn't mind but here I am - the green guy. Cool video and we need more;-) similar case with file names which have to be re-name maybe based on table from Excel and some first part of the old file name;P
I use to make whole text processing only using a string (since its max size is 2 billion characters), and split and join functions. I use ADO Text Stream library to "copy" text file to string, then parse the string... If I am not wrong, 2 billion characters would be the size of a 2 gigabytes text file...
There could by an improvement: Splitting the full file name first by the dot and then by the backslash will fail if a directory name contains a dot, E.g. "C:\user\2022.06.23.documents\letter.docx" Splitting the directory names and the filename first by backslash and then splitting the filename by dot should be more robust.
You misspoke around 4:22 when you said ubound()-1 instead of ubound()-i . This is the exact reason why very, very old programmers and FORTRAN programmers like to use k instead of i as a loop counter. In hundreds of lines of code, it’s very hard to see a 1 that should be an i, and the compiler won’t help. As for using lower case L, well, sorry, that’s a sackable offence. EDIT: 1:15
Interesting video. Very useful as the rest of the channel. Waaaaaaaaay to fast though. Makes it a long and painful watch, having to stop and rewind every 10 seconds to understand what is being done. With coding happening at the same time as the explanation the learning is A LOT harder. Nonetheless, congrats on the knowledge!
I don't mind the speed, but you can always change the speed down to 0.75, 0.5 or 0.25 using the settings. I generally use this to either increase or decrease the speed rather than backing up - depending on my knowledge of the subject etc.
I would like to see a featuring video with Mr Kelly and Mr Gould from Wise Owl Tutorials, the quality of VBA content in these two channels are amazing
@ExcelMacroMastery Thank you for sharing your knowledge freely, and for taking viewer comments as a sign of engagement, not criticism. You're the Maestro.
Your content is always top notch!
Looks like the only channel on youtube who loves VBA and knoows what really needed in everyday work!
That is lifesaver if you need to change something in csv without changing original format!
Thanks!
Excellent information, especially the last example of writing the contents of the array to a column!! I’m so glad that I had previously subscribed to your channel, otherwise I might’ve missed this information. Thank you so much for making this available!
You're welcome
Fantastic as usual Mr Kelly! And very timely for me as I am up to my neck in trying to sort out a database full of portly entered and inconsistent names. This will help a lot!
I have learnt VBA just from TH-cam in 3 months and created many projects for my organisation... Got recognised...
Thanks for such a great content
You're welcome.
I used to work with VBA a lot I'm still surprised that there are people still using it!
Great video really helpfull ,Thank you
Very nice work. Cograts Paul!
Thanks
Outstanding video 👍 ❤️
Glad you liked it.
Simple yet masterful 👏
Thanks Uriel
As usual, a great demonstration of you view to vba!👍👍👍
Thank you Paul! I enjoyed every single video you publish here!😁🍀🥳💚
Thanks very much John.
Very cool sir 👍
Very nice Paul, thank you 😊
Thanks Nader
Great video!
Thanks
Hi #Paul #ExcelMAcroMastery
How do I write array data back to Table object?
Hi, I hope you’re doing well !
I have a workbook that is used by multiple users through the network and it has a macro inside but some users have macros desabled. Is there a way to enable macros among the network users ?
Thanks !
Outstanding video. Is it possible to use regex to split text in VBA ? Thanks'
2:30 I am accustomed to seeing "delimiter", not "delimeter". I do believe that "delimiter" is the correct word, but apparently it is not a reserved word in VBA.
Join was new for me. Thanks.
You're welcome Omkar
Hi Paul,
Just a small comment. It's fast and straifhtforward. I am near 100% reluctant to use it because it takes only one delimiter. With little efforts it can be built a MySplit procedure/function which can take multiple delimiters. I use complex strings concatenations based on specific delimiters to see which is which. Maybe you will make a video with a MySplit function?
Glad you like the video. I might look at doing a MySpkit function in the future.
Hmm, this is interesting. If Paul make the video like you said, we can also learn about jagged array in vba. Perhaps.
1- Can the Excel add-in be programmed in another programming language such as C#, C ++ , Python or only through VBA?
2- Can we replace VBA in Excel with C#? If it is impossible, why not?
In office 365 subscription the dyanamics arrays formulas engine allows that the result can fill many cells at a time without using Ctrl + Shift + Enter. In case of working with arrays in VBA and print many results in a worksheet, it is no longer necessary to resize the range (Range.Resize method) because the Excel formula engine will do it automatically.
Thanks for the feedback. Many people still don't use 365 so Resize is necessary for them.
@@Excelmacromastery I found that curiosity while I esa creating a user define function.
We are living and working in the "in-between time", until Excel 365 is widely used.
Very amazing video but too fast ;) I need to go back each time;P If I had more experience I wouldn't mind but here I am - the green guy. Cool video and we need more;-) similar case with file names which have to be re-name maybe based on table from Excel and some first part of the old file name;P
Glad you like it
I use to make whole text processing only using a string (since its max size is 2 billion characters), and split and join functions.
I use ADO Text Stream library to "copy" text file to string, then parse the string...
If I am not wrong, 2 billion characters would be the size of a 2 gigabytes text file...
thanks for the video, but for beginners not easy to follow, it could be slower
What is the benefit of using Application.PathSeperator rather than just "\" ?
For regions or the Mac which don't use the backslash as the symbol. VBA will insert the appropriate symbol at run time.
There could by an improvement:
Splitting the full file name first by the dot and then by the backslash will fail if a directory name contains a dot,
E.g. "C:\user\2022.06.23.documents\letter.docx"
Splitting the directory names and the filename first by backslash and then splitting the filename by dot should be more robust.
You misspoke around 4:22 when you said ubound()-1 instead of ubound()-i . This is the exact reason why very, very old programmers and FORTRAN programmers like to use k instead of i as a loop counter. In hundreds of lines of code, it’s very hard to see a 1 that should be an i, and the compiler won’t help. As for using lower case L, well, sorry, that’s a sackable offence.
EDIT: 1:15
1:15 But nice catch, Albert.
2:44 is probably correct. to use "1", not "i"
@@houstonvanhoy7767 Thanks for that! McLean’s Law says that any attempt to correct an error will contain its own errors. That’s my excuse.
#Continuous#Improvement
!
I'm familiar with the famous Murphy's Law. Now I'll need to look up McLean's Law. :)
en.wikipedia.org/wiki/Murphy's_law
@@houstonvanhoy7767 omg this is getting comical. It’s actually McKeans Law.
Interesting video. Very useful as the rest of the channel.
Waaaaaaaaay to fast though. Makes it a long and painful watch, having to stop and rewind every 10 seconds to understand what is being done.
With coding happening at the same time as the explanation the learning is A LOT harder.
Nonetheless, congrats on the knowledge!
I don't mind the speed, but you can always change the speed down to 0.75, 0.5 or 0.25 using the settings. I generally use this to either increase or decrease the speed rather than backing up - depending on my knowledge of the subject etc.