Excel VBA Introduction Part 53.2 - Splitting Strings

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

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!

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.

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

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

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

These videos are awesome, they've helped me significantly in a short amount of time. I was wondering if you had any advice.
<possibly irrelevant info>
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).
</possibly irrelevant info>
<goal>
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.
</goal>

<possibly irrelevant info>
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.
</possibly irrelevant info>

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.

Excelent tutorial, thank you

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?

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

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

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

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

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

Fantastic, Thank You.👍