You are an absolute gem. I would love to shake your hand one day and tell you that you've taught me literally everything I know about macros. You're very clear, very engaging, very chill, and always one step ahead of what we want to and need to know. A million times, THANK YOU.
Hi Andrew, How are you, I think you will be good with the grace of God, I have one request to you, could you please upload a video tutorial about, how can we use RegulaExpressions in VBA. Thanks Kashif
Could I using the replace function to actually replace a whole cell reference to another cell reference. Say I have this formula in a cell reference and I want to replace a part of the formula. Do I have to use a string or can I use a cell reference?
hi wiseowl, first thanks a lot, really great channel for vba, i have small question why if i dont put "ts.close " and "ts.nothing" it gives some runtime error with some permission title? is it obligatory to put ts.close and ts=nothing?
I don't know why you're receiving an error. Closing the text stream isn't technically obligatory but it is best practice. Your object variable will automatically become Nothing when it goes out of scope. I'd suggest that closing the textstream is more important than explicitly setting it to Nothing.
I'm very new to VB and trying to learn it on my own. I successfully replaced spaces with underscores on one of my cells but need to do this on the entire column. How would I go about modifying my current script. Sub ReplacingStrings() Dim s As String s = Range("I2").Value Debug.Print s s = Replace(s, " ", "_") s = Replace(s, Chr(10), "") Debug.Print s
One other question if you don't mind. If I export my VB to a .bas file how would I go about running that every day on a excel file that's being updated each day on my network? Could that process be automated as a startup process when I turn my computer on in the morning?
You are an absolute gem. I would love to shake your hand one day and tell you that you've taught me literally everything I know about macros. You're very clear, very engaging, very chill, and always one step ahead of what we want to and need to know. A million times, THANK YOU.
You are very welcome! Very happy to hear that you've found the videos useful and thank you for taking the time to leave a comment!
Thank you, Dr.Wise! There is no one out there doing this educational videos. Appreciated
Changing Twilight to Terrible.... Savage.
Wiseowl is the best!
Tell us what you really think of twilight lol . Great series, Thanks!
Hi Andrew,
How are you, I think you will be good with the grace of God, I have one request to you, could you please upload a video tutorial about, how can we use RegulaExpressions in VBA.
Thanks
Kashif
So funny, and so useful!!! Thank you, Andrew!
You're welcome Alexander, thanks for watching!
Thanks Andrew, very useful.
This is TOO MUCH FUN. Thanks for this great tute. I might even be converted from Leila. Maybe.
Gharani?
@@johassan6509 yeah, but she's brilliant too. They're both great teachers in their own way.
How to replace
Could I using the replace function to actually replace a whole cell reference to another cell reference. Say I have this formula in a cell reference and I want to replace a part of the formula. Do I have to use a string or can I use a cell reference?
hi wiseowl, first thanks a lot, really great channel for vba, i have small question
why if i dont put "ts.close " and "ts.nothing" it gives some runtime error with some permission title? is it obligatory to put ts.close and ts=nothing?
I don't know why you're receiving an error. Closing the text stream isn't technically obligatory but it is best practice. Your object variable will automatically become Nothing when it goes out of scope. I'd suggest that closing the textstream is more important than explicitly setting it to Nothing.
Thanks.
I'm very new to VB and trying to learn it on my own. I successfully replaced spaces with underscores on one of my cells but need to do this on the entire column. How would I go about modifying my current script. Sub ReplacingStrings() Dim s As String
s = Range("I2").Value
Debug.Print s
s = Replace(s, " ", "_")
s = Replace(s, Chr(10), "")
Debug.Print s
End Sub
That was exactly what I needed and it worked perfectly. Thank you so much for your help.
One other question if you don't mind. If I export my VB to a .bas file how would I go about running that every day on a excel file that's being updated each day on my network? Could that process be automated as a startup process when I turn my computer on in the morning?
I will look in to that and let you know how it goes. Thanks again!