Excel VBA Introduction Part 53.2 - Splitting Strings

[@deninsrmic4165]

Hi Andrew, I must say this is one of the tutorials on string manipulation via VBA where I in recent six to 12 months extracted most of the knowledge you shared here with us in my work. Also other videos which deal with strings, I was able to extract most of gained knowledge, again thanks to you, of course few books are always helpful to have at hand. What I was really adamant at is to leave positive comment on using loop when it comes to splitting strings. I have watched this tutorial couple times in course of last two years, always reverting back to gather forgotten valuable information, but also to finally get behind the logic on larger scale of your do while loop when it comes splitting strings (32:32). It helped me applied this approach in my project and expand it for large data set with more than few conditions. I just wanted to say thank you for your effort and knowledge you share here with us and ask politely when possible I would be thankful to have the string split method via loop presented a bit deeper with more examples in one of you next videos perhaps. Do please keep posting videos on VBA. Thank you, all the best. 👍🍀

[@WiseOwlTutorials]

Thanks so much, it's great to hear that this video has helped you! Thanks for taking the time to write such a nice comment and for watching!

[@ThatYooChoobGuy]

Hey Andrew, these are fantastic, thanks so much for sharing! A year ago I was a complete novice to VBA, but with the help of these videos I've learnt how to program proficiently; I recently wrote a macro to interface with a structural analysis program, locate, extract, process, and format the analysis data, which saves me a ton of time at work. Could never have got there without these vids. The fore-thought that goes in to them is clearly evident, and it makes a huge difference: everything you do is clearly thought through and has a purpose and demonstrates a particular principle, which means every video is densely packed with really good info. Great job!

[@porkypine1888]

I know, they're sooo helpful!

[@maurocastagnera8949]

Dear Andrew, I have no words to describe the deep admiration that I have for your great skill in explaining so perfectly each step of this complex subject. I just finished a hard day's work but the first thing I just did at home is look for this video that you've suggested to me today and I would listen to you for hours without ever tiring. I really understand why, thanks to people of uncommon intelligence like you, the world and technology are increasingly advancing more and more to the benefit of the community. Believe me that even though I have never met you personally, my appreciation and thanks really come from the depths of my heart! Thanks again for all this and excuse me if my English is not perfect.

[@paraglide01]

Thanks Andrew, this was what I was looking for. Thanks so much for teaching really complecated stuff in a clear way.

[@krn14242]

Thanks Andrew. Great video as usual. On to the next one.

[@hericklenin]

Magnifico! Are you covering the Regex class in the future?

[@alanrobbo6980]

Fantastic, Thank You.👍

[@fromdeskjockeytotraveljunk4985]

Great work on you videos!! I have bought your book. Cannot wait to read it and start learning even more VBA. Do you have any other book recommendations to improve me VBA knowledge?

[@sanketnarkhede2585]

Hey, If I take filename as input and I've to split the filename and rename it , how can I do , could you please explain

[@WiseOwlTutorials]

Hi Sanket, you can do this in a few ways but I prefer to use the Scripting Runtime library. Here's some basic code for this: Sub Rename_File() '1) Choose Tools | References... '2) Select the "Microsoft Scripting Runtime" library Dim fso As New Scripting.FileSystemObject Dim FileToRename As Scripting.File Dim OriginalName As String Dim NewName As String OriginalName = "C:\My Folder\My File.txt" NewName = "C:\My Folder\My New File Name.txt" If Not fso.FileExists(OriginalName) Then Exit Sub Set FileToRename = fso.GetFile(OriginalName) FileToRename.Move NewName End Sub

[@kamalkumara5338]

Hi Andrew, this is kamal I want to know how we can extract data from selected excel in folder.

[@janezklun]

Excelent tutorial, thank you

[@nuhzakir8896]

Thank you for the video. Especiallay last part of the video was very useful. Why not ts.readline direction to right ? Because direction of data is to right. e.g.(Harray Potter.....) but ts read like this (title,avatar,titanic.....). And finally i want to ask we can use an openfiledialog or an savefiledialog like c# ? You write the file's path.. Can we choose file's path with openfiledialog ? Thank you so much.

[@nuhzakir8896]

***** thanks for the replay!

[@shapedthought]

The 'split' function doesn't appear to be showing in my VBA editor, anyone else had this issue?

[@vineetat2]

Andrew. you are 'Albus Dumbledore' of VBA university.

[@WiseOwlTutorials]

:D I hope that I don't meet the same fate!

[@vineetat2]

@@WiseOwlTutorials unfortunately i haven't seen all harry Potter movies. I love your way of teaching and you are best vba teacher without any doubt.

[@WiseOwlTutorials]

@@vineetat2 Thank you so much Vineet!

[@Fly0High]

I keep referring back to this video over and over... strings are a bit of a nightmare!

[@WiseOwlTutorials]

Happy to hear that it continues to be useful!

[@salvatorescuderi6928]

Florian Henckel von Donnersmarck???lol it's my next username!! ahah

[@unhott1893]

These videos are awesome, they've helped me significantly in a short amount of time. I was wondering if you had any advice. Workbook1 has several named ranges on several sheets. Workbook2 has a macro in it that adds values to those named ranges (works perfectly) and then it adds linked cells to those named ranges in WB1 to pull from those named ranges (works perfectly). I want to add a macro that will open the precedent cell and automatically select that range, just like if you did this sequence of events in excel: select cell containing link to precedent click formulas --> Trace precedents --> double click the arrow which opens up a Goto menu with the list of precedents (my list will only have 1) --> click go this changes to the other wb and selects the correct range on the correct sheet automatically. this only appears to work if both wb are open. i think i could find a way to split the cell's .formula into a file location, file name, and named range substrings, figure out if the wb is open, then try to application.goto that reference, but i'm not sure if there's a simpler way and i'm working too hard.