Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO

By Andrew Gould

[njmust]

you are the most genius person in the world i like your teaching method and your ability to teach the people.

[Alex-olbv]

Very useful and comprehensive, thanks alot. Using stored procedures is the way to go when working with sql server from vba. Much cleaner than building out the full query string in the vba code.

[JustChillinAtHome]

Excellent video! The way of explanation, extend to which details are shared and pace of explanation is spot on.

[nicor]

I just pill up another 'thank you' !
Really appreciate your videos : clear examples, easy to follow for non native English people (like me), etc...

[JIYA_ARTIST]

Hey Andrew, have seen few of your videos and these are really amazing. I compared it with other YouTube channel s and it is of no match. You really are a awesome teacher. Great work buddy.

[daves]

absolutely awesome. We are using this for a DB2 solution which means that you dont include the @, then it works. Just to help others out

[pbassociates]

Hello, Mr. Andrew First of all let me thank you for sharing such valuable material on excel VBA a really big thank from the bottom of my heart, I'll be grateful to you if you will share your knowledge and cover basic aspects on window API VBA.

[KhalilYasser]

Thanks a lot Andrew for all these treasure. I appreciate a lot your efforts.

[agthawkins]

God bless you, you are saving my behind

[alexandreguy]

Hey Man, so glad I found this video. Better than Stack Overflow!

[ife]

Thanks a lot for this video. Learning so much from you

[adarshtewari]

Thanks again Andrew. Great tutorial and amazing knowledge

Excelente turorial, Gracias Mr Andrews

[pradeeprawatvlogs]

Hi sir thank you so much sir your videos help me a lot your videos make me stand out from the crowd

But sir due to lack of time now a days i am not able to watch your videos.
thanks a lot sir 🙏🙏🙏🙏 for providing such a valuable amazing work by you

[himanshupathak]

Cud u plz make 1 video tutorial on vba. Your way of making understandable us is very good.

[VincentHardwick]

For anybody else watching from 32:14 onwards who might wonder how to retrieve the output value returned by a stored procedure which does NOT use a declared output variable, i.e. using a RETURN statement instead, I discovered that an output variable is automatically included in the Parameters collection of the Command object when it is refreshed, and it is always named @RETURN_VALUE.

[MarkJasonLleno]

Hello sir Andrew. First of all I would like thank you so much for all the videos in your channel. I would like to say that you have been my teacher for almost 7 years now. I have learned your style and even though there are lots of excel vba books out there but still for me you are the best teacher when it comes to excel. I know there are great gurus out there but when it comes to explanation you are the best. With you out there I can say that excel vba can do what other programming languages can. Now that you have opened the topics about internet connection is okay if we ask a video on how to manipulate excel file that is stored in OneDrive or Cloud using vba? The reason for this is I want to create a program that my students could access from there home because of the current situation COVID 19. And one thing more sir. I would like to learn also how to use API functions from you if it is okay. Thank you so much sir in advance..

[shinyean]

Hi Andrew, your video really helped me with inserting data into SQL from Excel VBA by using stored procedure. However, I'm facing another problem now, can I know how do you use stored procedure and parameters with ADO for unicode like Japanese characters? Thank you very much.

[ganesh]

Great videos but my one question after watch your series, can I get job in VBA and excel and perfect with good salary

[naveendayalan]

i did a automation for to download the files in internet explorer, while downloading it asking for open, save or cancel. i am stuck up with this situation. i save automatically without prompt message. kindly help on this... Thank you