My code here loops through my folder and my files inside the folder and use.find and copy the strings into a new excel sheet and then with all the data in the new sheet, i will use .Find(What:=) to find the strings inside the new worksheet and then either split or use Right,Left,Mid functions, so...
@SimonForsberg I"m giving it a go in VBA. 7 stars at day 8. Day 7 part 2 is giving me a bit of a headache my computer passed all the testinputs but gives the wrong answer. Time to write some proper ducky tests methinks,
I am a technical reviewer/writer and I use I use VBA for Word a lot to manage issues in Word documents I receive. I have frequently come across niggles when using Collections, Scripting.Dictionaries or Array lists. Then I saw some posts on creating a C# library for consumption by VBA. After mu...
@BloggingDuck Very appreciated. Feels like an article of two unrelated parts: 1) the Doc Class at the beginning. 2) Work[book|sheet] referencing after the Accessing Worksheets heading. Am I missing the link between the two?
If I'm reading the first part correctly, in Excel the evils of putting my code in the code behind are: 1) any (implicit or explicit) public method is available in every other code module, 2) ActiveWorkbook is the work of Satan and to be avoided at all cost.
Oh, and they require special handling when importing/exporting the code to ensure that they don't lose all the special things about them as doccls modules.
@Cyril Because the computer has to calculate numbers bigger than Long. The the compuer uses self modifying code so that it can load numbers which have been stored as LongLong. This threw up a deficiency in the Kvp indexer in that it is based on C# int (equivalent to VBA Long). The Kvp (operative through com) is very fussy so if I sore a value using a Long value as a Key then you get an error if you use the same number but as a VBA Integer or LongLong.
@Cyril e.g. One of the test cases for day 9 was for the computer to calculate 34915192 *34915192
RD News update: 2018 was +24K views over 2017. 2019 is +24K views over 2018. Was hoping for 50K views this year, we're currently just under 60K and there should be another bump in a week or two when 2.5 is released!
More like dismayed. Toggling off formula autocompletion via the UI Application.DisplayFormulaAutoComplete = False instead records Application.EnableCheckFileExtensions = False is an 'Uh.... Wut?' type of fail.
@Freeflow For Day 7 Part 2 you need to make sure that your programs can pause when they need more input and that they keeps their state (with the current memory) until they get another input. But yeah, test-cases are good to have.
> They have set of punishment rules for employees, for example starting the working hours is 8 and if I go to work after 8:45 they record that as an absents and will double it if I don't go to work, meaning they will cut a day of my monthly payment and will cut another extra day for punishment if I don't go to work that day.
Wow. That's actually pretty lenient they have a whole 45 minutes...
I'd like to ditch them and go hosted on Azure, but Azure has this "we're all about .NET Core" buzz/feel to it, and I'm pretty sure our indenter won't run on Core.
@SimonForsberg I talked to an AWS advocate from Amazon a few months ago. They were trying to tell me the cheapest I could get a SQL DB for dev work was $70/month.
I don't know if that's accurate, or they were trying to sell me a business plan, but I pay $5/mo for an unused DB at Azure, and $15/mo if I actually use it regularly.
@Hosch250 Depends on what kind of DB you want/need and how much you would use it. I'm currently running DynamoDB (a NoSQL alternative) for free in AWS.
I believe AWS supports Postgres as well, but I'm not sure how much it costs.
@Hosch250 Postgres is fairly simple. Quite similar to many other SQL DBs.
@Hosch250 Ah, right. Sure, that's an option but I personally like that AWS has everything, instead of having the db here and the website there and so on.
> Per the instructions [here](https://rubberduckvba.wordpress.com/2019/07/15/modern-vba-best-practices-default-members/#comment-2623) for the case that one does not have 20 rep on SE, which I don't as I did not have an account until very recently. Please just let me know what you need from me.
I chose Thanks! as the "issue" because it seemed like the most appropriate for such a request. Rubberduck has been a very beneficial tool for getting unstuck on a project that felt like it had an unmana
so coffee is the first thing in the morning (whenever that is) and the second coffee is "not before three and not after six, unless it's friday, saturday or sunday"
In my case, I won't drink the coffee because it tastes horrid. The funny thing is that I don't mind coffee's smell but not taste. Tea is my substitute.
@Vogel612 Indeed.
One observes that coffee and beer both are basically acquired taste. Hand either to a kid and they go yeech. Yet adults can't get enough of either.
@this mr sister chugged ehr first beer at 2... my father opened one, set it atop a speaker, and went to show a buddy something in the garage. came back and it was gone
@mansellan think about it: without the I prefix, you have to remember the interface types for the entire framework to know (without looking at any docs or source) what's what. With the I prefix, you can look at a type you've never seen before and instantly know that it's an abstraction.
just get the world to agree that if a person makes a variable, they must put their initials at the start. then we know who to blame for their preferred notation. "mgTSource" "who used to work here with initial's MG?!?!?! WE MUST SHAME THEM!"
public class LinkedList<T> : System.Collections.Generic.ICollection<T>, System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IReadOnlyCollection<T>, System.Collections.ICollection, System.Runtime.Serialization.IDeserializationCallback, System.Runtime.Serialization.ISerializable
public class ConcurrentQueue<T> : System.Collections.Concurrent.IProducerConsumerCollection<T>, System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IReadOnlyCollection<T>
Weird timing on this thread, I've finally gotten around to putting together all our IEnumerable extensions into a lib at work, just before I left today...
@user12506685 don't hesitate to ask anything, whether it's about using Rubberduck, contributing to Rubberduck, VBA in general, C# or .NET, how SE Chat works, how SE works, or anything else :)
VBA Rubberducking
VBA Rubberducking