วีดีโอ

So nice of you

Glad you enjoyed it!

Thanks for the comment, after the forth minute, I am zooming - 4:13.🙂

@@vitoshacademy Sorry Sir, I was too early to comment . Thanks a ton

@@SasiKumar-sp4py No worries, I hope you liked the video.🙂

Hello, and thank you for your question.😊 If you are using the code from the article, then try these steps to avoid the compiling error: 1. Delete `Option Explicit ` 2. Make sure that you are having a worksheet named `Sheet1` 3. Put the code in a module. I am away from the keyboard right now, but if the compiling error still exists, try asking in Stackoverflow.com about it, if you tag the question with #Excel and #vba, and provide the code, and explain where is the compiling error, someone will probably answer in less than 1 hour. The #vba community there is helpful. Enjoy your day😊

Thanks for the nice words :) Actually there are some timestamps in the contents. Or do you mean somethign else?

🙂In general, I am not the ultimate "knowledge tank" of VBA, there could be a few solutions I am not aware of, but in theory you can easily build a `Sub` that gets an array and based of its dimensions it puts it into a range. Anyway, there are a few decisions you should make - if it is 1D array, how are you going to paste it? (As a column or as a row) What would you do with 3D arrays? Return error, or just write the first 2 dimensions and forget about the rest?

Thanks for the question! Actually, I have thought of some possible solution for that problem and it might be a working one, if the array is a smaller one. If it is big, then it probably will work as well, but more time would be needed for the loop. I have made a video here, for the solution - - th-cam.com/video/9zzY7qLu92U/w-d-xo.html. Enjoy it!

Hi and welcome! :) Your question sounds like a micro project. The best advice I can give, is to try to write some [MCVE](stackoverflow.com/help/minimal-reproducible-example) and then post it either in stackoverflow.com or codereview.stackexchange.com. In order to be a bit more helpful and not simply telling you nicely to ask somewhere else, if it is really a micro project, you can implement a `class Stocks` with `UpdateStock()` function, that takes transactionType and keeping Stock as a dicitonary. Something like that: class Stocks { public Dictionary<int, int> Stock { get; } = new Dictionary<int, int>(); public void UpdateStock(Product product, int quantity, string transactionType) { if (Stock.ContainsKey(product.Id)) { if (transactionType == "In") Stock[product.Id] += quantity; else if (transactionType == "Out") Stock[product.Id] -= quantity; }}} After implementing the dictionary, you can consider whether you really need a database behind it or you can dump the data into a csv file and read it each time when the program is ran. For a small "homework" project that is a feasible solution.

Thanks!

Glad it was helpful!

@@b99eu You mistakenly posted your question to me and not the author.

Hi! I did not know it was different in previous versions of Word, but if it was, then the update is strange, indeed.

True. In previous versions the autoconnect did not need drawing canvas. Never ever used 'drawing canvas', hated it.

Thanks for the feedback. Can you please share which part of the lesson was the most confusing one, so I can try to improve it the next time?

Great to hear!🙂

Hi! Thanks for reaching out! Any question in StackOverflow with 100+ reputation (as a sum of all answers and the question) is really worthy, so you can start from there: - stackoverflow.com/questions/37806159/what-is-a-complex-type-in-entity-framework-and-when-to-use-it Then, take a look at the referred links, as these are also worthy: - martinfowler.com/bliki/ValueObject.html - weblogs.asp.net/manavi/associations-in-ef-4-1-code-first-part-2-complex-types - learn.microsoft.com/en-us/previous-versions/dotnet/netframework-4.0/cc716799(v=vs.100)?redirectedfrom=MSDN In general, Microsoft is not a bad option for learning as well: - learn.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-a-more-complex-data-model-for-an-asp-net-mvc-application That's all. Enjoy the learning experience🙂

@@vitoshacademy Thanks so much Vitoshacademy! Definitely will enjoy.

Congrats :) Now the sky is the limit with Excel :)

Thanks :)

Welcome :)

What is MS 2011?

Microsoft 2011 version. tx@@vitoshacademy

Do not have that version installed, sorry. (but I guess you found a workaround after 5 months)

Hello there 👋

Thanks for the question🙂🙂🙂 I don't know such a way.🤔

Thanks, Sam, I appreciate the positive post🙂

Hi, thanks for the comment. Which visual studio are you using? It can be based on that, is it the same I am using? I guess it is either this or you are missing some library or anything similar. stackoverflow.com/questions/64315213/visual-studio-2019-doesnt-show-me-net-standard-2-1-and-net-core-3-1-as-part-o

Thanks, I will consider it.

Real world use cases would definitely be helpful. Comparison vs other data structures/methods etc. Thanks for the video @vitoshacademy

Hi Pablo, stackoverflow.com is probably the best place to ask this question, as many more people will see it and will answer it promptly.

Hi! Take a look at this topic stackoverflow.com/questions/8742581/mutilevel-include-in-c-sharp-linq, and if you still do not understand it, try to write a question in Stackoverflow.com. Make sure to put the code that does not work, while trying to retrieve the ID, the people there will definitely help you, if you put some 10-20 lines of relevant code and describe your question well. 😉

No idea, it works for me. It could be that you are trying to access the pdf through a proxy or something. Here it says so - github.com/chrismattmann/tika-python/issues/158 Try to access a PDF file, which is based in the country where you are based (or your proxy).

Thanks for the nice words 🙂

I guess this is a bookmark for you?

Well, it took me some time to find it out myself, so I decided to make a video. Btw, do you have any ideas about VBA/Python videos?

I am a bit away from keyboard now, but if I believe stackoverflow.com, then either "tools>options>text editor>language" or simply rebuild. stackoverflow.com/questions/9131507/navigation-bar-gone-since-vs-11-install

You are welcome 😊

Hi Singh, using zoom will be a good idea, but I doubt I will be able to make it for my next videos. Enjoy your day🙂

Welcome. Although I have not published anything new since months, I like reading positive comments 🙂

Thanks 😊 I really enjoy reading positive comments 😀

Hello, thanks for the question. As I really am not a compiler myself:), the best answer I can come up with is - replicate the code, put a break point on the correct place and debug. It should be visible. Or make a mcve (stackoverflow.com/help/minimal-reproducible-example ) and ask in StackOverflow.com, someone will debug for you there (if you make the mcve).

NEVER mind i just did a mistake ... YOU'RE A LIFESAVER THAAAAAAAAANK YOU SO MUCH

You are welcome 🙂

Thanks for the positive comment 😊🙂

Hi, Music 52, thanks for commenting :). If you want to share the database, you need to put it somewhere, where other people may have access to it - on a hosting or on a cloud (AWS, Azure or others). Both AWS and Azure have out of the box solutions for MSSQL - aws.amazon.com/sql/?blog-posts-content-windows and azure.microsoft.com/en-us/services/sql-database/, and if it is for a non-commecrial usage (or a student's account) there could be something for free (not sure, though).

Thank you🙂 Sounds like a nice idea for a next video, adding a Postman as well. BTW, I think I have a video for those, but for C#.

Should be possible. 🙂

Hm... Did not think about the import. The way I work is the following - export => git => further work => export => git... The idea is to get the "history" of the project this way.

This runtime error occours when an item (sheet, module, userform, class...) has no line of code. I solve this error with the following code For Each item In ThisWorkbook.VbProject.VBComponents Dim count As Long count = item.CodeModule.CountOfLines If count = 0 Then count = 1 lineToPrint = item.CodeModule.lines(1, count) Debug.Print lineToPrint textToPrint = textToPrint & vbCrLf & lineToPrint Next item

When "item.CodeModule.CountOfLines" = 0, then the code crash

I am away from keyboard, but in general a vb library is missing. Google the error, there should be a solution, explaining how to add it. In general, from Vbeditor, add reference and check the missing library. Then try to compile. If you still cannot manage, drop me a line and will update the article with the added library explicitly. Thanks 🙂

I have added the instructions how to add the Extensibility 5.3. library at the bottom of the article.

Strange, I thought I have shared it. Will check these days, currently browsing from a phone, but I think the correct one is this: github.com/Vitosh/ASP/tree/master/TodoApi

Nope, but if you give it a try with the code from the video, you would probably be able to do it yourself. (50% of the code for multiple filtering is there :) ). If you struggle, try making a mcve and ask a question in StackOverflow, people give amazing answers to questions with mcve.

You are welcome 🙂

Thanks for the good words and the appreciation. It is really nice to see your efforts appreciated :)

Thanks. There are plenty of ways to do filtering and ordering in C#.

If the size is predefined, it is easier - use hard-coded values for the matrix initially. It does not matter it is not with numbers, but with chars. Whatever it is, follow the logic and fill it.