|
|
|
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.
|
|
|
|
|
|
Have you noticed the 2036 BUG in you link?
The Network Time Protocol has a related overflow issue, which manifests itself in 2036, rather than 2038. The 64-bit timestamps used by NTP consist of a 32-bit part for seconds and a 32-bit part for fractional second, giving NTP a time scale that rolls over every 232 seconds (136 years) and a theoretical resolution of 2−32 seconds (233 picoseconds). NTP uses an epoch of 1 January 1900. The first rollover occurs in 2036, prior to the UNIX year 2038 problem.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
I hadn't. Well spotted.
Chaos comes sooner than we think ...
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
|
digimanus wrote: every 232 seconds (136 years)
Last time I checked, there were more than 232 seconds in 136 years!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
It would seem that just the OS's will need to be updated. .Net code, for example, is high enough in the programming levels that my code won't care, as long as the DateTime object works in .Net.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
It will be interesting to see how many 32 bit systems are still in existence in 2038. By then, I would imagine the majority of Unix-like systems would have switched to a 64 bit epoch.
Though, even with 64 bit, I guess we'll have to deal with the problem again in the year 292,277,026,596...I might miss that one
|
|
|
|
|
Back in 1999, this was the issue that my coworkers and I kept trying to tell people would be a much more pressing situation. Hopefully, most 32-bit architecture will be retired by then.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
It will affect digital TV as well - cable, terrestrial and satellite as well.
|
|
|
|
|
... to start a campaign to get IT teachers to sign up to CP, and send some time hanging around in QA answering their own homework questions?
It would be a lot more peaceful there after each year's new wave of student expulsions ... and we might actually improve the quality of the next generation of developers.
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I find it not evil, I find it even a good suggestion.
Each Homework question answered with a unique thing in the code, and then you can spot the students copying from the internet (and send them home)
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.
|
|
|
|