Видео

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 - - ruclips.net/video/9zzY7qLu92U/видео.html. Enjoy it!

Glad it was helpful!

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

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.

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)

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

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

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🙂

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).

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

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.

Fullscreen and 1080HD should be ok... Or should I zoom a bit?

@@vitoshacademy man when I saw your videos intro, i thought, why so so few subscribers? and why no few views? and in first 10 seconds, I got the answers. Cant see a damn thing. text is so small that its impossible to read. consider improving in that part.

@@Harish-ou4dy thanks, I had to zoom a bit indeed.