|
Sander Rossel wrote: Apparently, the guy's from the USA though, so I don't know if the Dutch language actually inspired him or if it's some coincidence.
Kind of 
Verlorener is a name derived from the German word “verloren,” which roughly translates to forlorn and hopeless. It is Werstler’s antidote to his disenchantment with working the same musically restricted path for the past decade-plus.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
So the German word verloren is the same as the Dutch word verloren except he got it from Germany and not the Netherlands?
I'll just take that as "the Dutch language actually inspired him" 
|
|
|
|
|
It did.
Why Are People From The Netherlands Called Dutch? - YouTube[^]
Ignore the so-called explanation on how you can use "Holland" to refer to the Netherlands; it's wrong.
Also, part of our kingdom is in a sub-tropical climate; you wouldn't call those Holland, would you?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Eddy Vluggen wrote: how you can use "Holland" to refer to the Netherlands; it's wrong.
Yeah, that's what he explained, didn't he?
Eddy Vluggen wrote: part of our kingdom is in a sub-tropical climate
This one confuses my dad. He's into biology, so once in a while he reads an article like "new species of brightly colored frogs discovered in the Netherlands!" and he's like "what the hell!?", but it's on Curacao or something.
Technically they're not wrong
Anyway, I'm all for calling the Netherlands Holland Goeree-Overflakkee, because that's really the place to be! 
|
|
|
|
|
|
|
My daughter manages a college bookstore. Their parent company passes around a lot of Excel spreadsheets, and there's apparently a cottage industry in Excel macros among the manager community for reports, conversions, etc. She'd like to customize some of them for her own use.
Stop laughing, dammit, this is my kid here - this is serious!
Can anyone recommend a good book or two on Excel macro programming? There's a crap-ton of them out there.
And yes, I don't miss the irony of the request coming from the manager of a bookstore.
Software Zen: delete this;
|
|
|
|
|
Import these sheets in a DB Server and do something proper with that!
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
That's probably beyond her resources and her needs. It would certainly get dad involved for some *cough* free *cough* development and support time, though.
Software Zen: delete this;
|
|
|
|
|
Hopefully @Maciej-Los will drop by
|
|
|
|
|
|
|
I can suggest a couple to avoid ...
Excel VBA For Dummies, Walkenbach ... although it does seem rated by other readers
Professional Excel Development, various authors, Addison-Wesley
A guide to the wise ... if the macros have been recorded tell her to start by getting rid of all the unecessary waffle ... all the properties of a cell for example are not required to just change the forecolour.
And anything that says .Select or .Paste needs ripping apart 
Edit - this forum has been useful to me in the past ... Excel Tips & Solutions Since 1998 - MrExcel Publishing[^]
|
|
|
|
|
Excel-123 for dummies? (no reflection on your family)
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
Best tip I can give is the macro recorder. Start recording a macro, do via the menus etc what it is you want to do, stop the macro and look at the macro code.
|
|
|
|
|
|
This is all you need to know:[^]
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
I don't think you can consider any business real (no matter the size) unless there is at least 2 people playing a rousing game of "pass the spreadsheet". So I'm not laughing.
|
|
|
|
|
There are also several powerful addins out there that she can buy and use.
|
|
|
|
|
I must admit that this is a new one to me (every day's a school day!)
Year 2038 problem - Wikipedia
Personally, I'm planning on being either retired, dead or both by then, but is anyone preparing for it?
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
I'll be in the 60s. I don't expect to be dead so soon, and I suppose I will still be in active (retirement in my generation is going to be a bit more difficult)
About the preparation... I am going to investigate a bit and if I start something from the scratch, then I'll try to avoid it.
In Legacy mode... I think I will wait to see if it is really such a bad thing.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I'm probably fooling myself if I think I'll be retired by then, to be honest, but death might present the chance to take a bit of time off work!
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
"For example, the bug makes some Android devices crash and not restart when the time is changed to that date.[6]"
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
. Every time I have to ![Elephant | [mastadon]](https://www.codeproject.com/script/Forums/Images/elephant.gif)
with an