Whole last week I was struggled working with innerHTML and I cursed everything in this world. But only today I watched you video. Now I curse myself and thank you, Andrew. You are amazing person!
Andrew thanks for another useful video in this series! It has become a nice sunday routine for me to watch them and practice along, to implement your solutions in my own projects and ideas! Best regards, Ben
Andrew, your classes are really amazing. Keep doing this job, cause you help us a lot! Can you give a class about Regular Expressions (RegEx)? There's not much video content about this. Thanks!
I am able to solve my many problems just because of your hints and help. I am Structural Engineer, and trying to develop an application in VBA to customize output of a software. There are some undocumented functions (manual does not show these functions, in spite of their availability) which were hidden to me, and I was stuck. Suddenly, i got an idea given by you to see the Library of that object in VBA Explorer and found required function, and my problem is solved. I am very very grateful to you and pray for you success in every field of life.
I'm in exactly the same boat Atif. I've written a Macro to extract, process and format data from Larsa 4D (I'm a bridge design engineer), but it's really difficult trying to push deeper in to the program because the help file only covers basic VBA functions. I've tried looking through the Object Browser, but so far it's not helped me with the functionality that I'm trying to implement, though I think this is due to my general unfamiliarity with the Object Browser. If you found any particular web pages or tutorials on this that you found helpful in this regard please share :) And I'm curious what software you were working with?
Dear Brother, I am not familiar with Larsa 4D, but I know one thing... If there is a will, there is a way. I pray for your success. In Sha Allah (if God Wills), you will soon get your desired results. I stuck for three days, and finally, today the problem is solved. I am also new to Object Oriented Programming, and following the guide lines of great person, who increased my thirst of learning VBA.
Very cool array Andrew. Sure reduces the processing time to nothing even with all those calculations. I need to incorporate this idea into reporting some CBT compliance reports. WOW.
Another great video Andrew, thanks! Funnily enough, creating an add-in like you show at 26:25 is exactly what I'm currently working on, with the help of your videos! So that was pretty funny seeing this. Would you be willing to share this? It would be a great starting point for me, as it'll be my first excursion in to Forms. I'm a structural engineer, so I often want to put in Greek letters, superscript/subscript, and some geometric symbols. The built-in Symbols tool leave a lot to be desired, so I'm basically looking to create my own that has the characters I commonly use.
Managed to figure it out with the help of your videos. I've similarly created a Quick-Access link as you did, though I've tailored the User Form to better suit my needs. Really happy with the result: goo.gl/photos/X4BRRbZU6twoHayB8 Only slight disappointments: 1) I found it's too risky to insert the symbol directly in to the worksheet, as using a macro to do this is not reversible (no 'undo' ability); this could go really badly wrong. So I've simply resigned to copying the symbol the clipboard to play it safe, requiring an extra step to paste it in with Ctrl+V. 2) I can't fire the macro while editing a cell (as you can do with the built-in Insert Symbol tool). I'm happy with what I have, but if you know any workarounds for these issues let me know :) Anyway, thanks again for these videos; they're really useful. Cheers Dan
Oh yeah, that'd work. Though for what I'm doing I think the functionality I have currently would probably suffice. I really appreciate the response though; saves me spending ages trying to implement unsupported functionality!
Hi Andrew, Can you please explain how place a screenshot of any window in excel using VBA. I did not find the solution for this in TH-cam. Please help me. Thanks in advance.
Whole last week I was struggled working with innerHTML and I cursed everything in this world.
But only today I watched you video.
Now I curse myself and thank you, Andrew.
You are amazing person!
:D I know that feeling! Thanks for the comments and for watching, Alexander!
You make VBA look easy
Thank you George, lots of practice!
As usual, you are outstanding Andrew. Thank you so much for this great video.
Andrew thanks for another useful video in this series!
It has become a nice sunday routine for me to watch them and practice along, to implement your solutions in my own projects and ideas!
Best regards,
Ben
Andrew, your classes are really amazing. Keep doing this job, cause you help us a lot!
Can you give a class about Regular Expressions (RegEx)? There's not much video content about this.
Thanks!
I am able to solve my many problems just because of your hints and help. I am Structural Engineer, and trying to develop an application in VBA to customize output of a software. There are some undocumented functions (manual does not show these functions, in spite of their availability) which were hidden to me, and I was stuck. Suddenly, i got an idea given by you to see the Library of that object in VBA Explorer and found required function, and my problem is solved. I am very very grateful to you and pray for you success in every field of life.
I'm in exactly the same boat Atif.
I've written a Macro to extract, process and format data from Larsa 4D (I'm a bridge design engineer), but it's really difficult trying to push deeper in to the program because the help file only covers basic VBA functions.
I've tried looking through the Object Browser, but so far it's not helped me with the functionality that I'm trying to implement, though I think this is due to my general unfamiliarity with the Object Browser.
If you found any particular web pages or tutorials on this that you found helpful in this regard please share :)
And I'm curious what software you were working with?
Dear Brother, I am not familiar with Larsa 4D, but I know one thing... If there is a will, there is a way. I pray for your success. In Sha Allah (if God Wills), you will soon get your desired results. I stuck for three days, and finally, today the problem is solved. I am also new to Object Oriented Programming, and following the guide lines of great person, who increased my thirst of learning VBA.
Very cool array Andrew. Sure reduces the processing time to nothing even with all those calculations. I need to incorporate this idea into reporting some CBT compliance reports. WOW.
Another great video Andrew, thanks!
Funnily enough, creating an add-in like you show at 26:25 is exactly what I'm currently working on, with the help of your videos! So that was pretty funny seeing this. Would you be willing to share this? It would be a great starting point for me, as it'll be my first excursion in to Forms.
I'm a structural engineer, so I often want to put in Greek letters, superscript/subscript, and some geometric symbols. The built-in Symbols tool leave a lot to be desired, so I'm basically looking to create my own that has the characters I commonly use.
Managed to figure it out with the help of your videos. I've similarly created a Quick-Access link as you did, though I've tailored the User Form to better suit my needs. Really happy with the result:
goo.gl/photos/X4BRRbZU6twoHayB8
Only slight disappointments:
1) I found it's too risky to insert the symbol directly in to the worksheet, as using a macro to do this is not reversible (no 'undo' ability); this could go really badly wrong. So I've simply resigned to copying the symbol the clipboard to play it safe, requiring an extra step to paste it in with Ctrl+V.
2) I can't fire the macro while editing a cell (as you can do with the built-in Insert Symbol tool).
I'm happy with what I have, but if you know any workarounds for these issues let me know :)
Anyway, thanks again for these videos; they're really useful.
Cheers
Dan
Oh yeah, that'd work. Though for what I'm doing I think the functionality I have currently would probably suffice. I really appreciate the response though; saves me spending ages trying to implement unsupported functionality!
Hi Andrew,
Can you please explain how place a screenshot of any window in excel using VBA. I did not find the solution for this in TH-cam.
Please help me.
Thanks in advance.