6,738 reputation
1524
bio website it.knightnet.org.uk
location Sheffield, United Kingdom
age 54
visits member for 2 years, 6 months
seen 2 hours ago

IT Consultant

Web Links:


2h
comment Pad a number with prefix zeros no and decimal place in Excel?
No problem. Feel free to accept my answer :) It was late though so I did miss the obvious SUBSTITUTE!
18h
comment Short-circuited ethernet wiring? Cable tester loop
Without knowing what is at the other end of the cable, it is pretty impossible to give an answer. Is the other end patched to anything useful/working?
Oct
30
comment Using “Outlook:// Protocol”, Open Current Instance of Outlook, not New Instance
You beat me to it! One note however, if using the Office 365 version of Office 2013, note that Office is installed in a different location by default so you need to alter your registry entry to match.
Oct
30
comment Add shared OneDrive document to my drive
As stated, open the original in the Word application and Save As... choose your OneDrive as the location (if you have the OneDrive application installed). If you don't have the application, save to your Documents folder and then upload to your OneDrive via the web interface. Then share with other people.
Oct
29
comment Create copy of variable sized Excel table
Well, the 2nd method is certainly workable and I use it for a number of bits of complicated data analysis. However, if the data is important to you and has worth from a business perspective, it is probably worth having something a bit more robust. Do yourself a favour though - don't bother with Access if you can help it. Instead go for a database engine (SQL Server, MySQL or whatever) with a web front end. Far more flexible and robust in the long term.
Oct
29
comment Can't boot after hardware upgrade
As I said, you may be able to run recovery on it without necessarily loosing everything. However I would say that Windows 8 is much better at this than 7. The problem with installed apps is that they tend to put "stuff" all over the place and it is nigh-on impossible to capture all of that and put it on another computer. You will have a variety of files and registry entries. Some of those, especially for games, are specific to the hardware so it is very unlikely indeed that the game would work anyway I'm afraid. The best you can hope for is keeping any saved games, they should transfer OK.
Oct
29
comment Safe to charge USB devices while doing other power-consuming tasks?
Most laptop/tablet USB ports will not allow more than 0.5w which I seem to remember was the original maximum.
Oct
29
comment Safe to charge USB devices while doing other power-consuming tasks?
I've seen too many cables damaged like this. The old Apple cables especially are susceptible to wear and you've only got to knock it or tug it a few times before you will damage or wear the little locking clips - after that, it will start to fall out.
Oct
29
comment Add shared OneDrive document to my drive
I'm confused I'm afraid. The doc belongs to someone who has shared it, you want to further collaborate? So get the originator to share to the others. If you want a COPY to collaborate with others, make the copy as I've said - save it to your OneDrive and reshare.
Oct
29
comment OneDrive for Business Long filenames will not sink on one computer, ok on others
Some more info would help here. Such as the path's in question. Also, do you have the same user names on both platforms?
Oct
28
comment Batch files to combine multiple files (that have parentheses in their names)
No need for PERL if using Windows. Use PowerShell with the suggestion from Berend to us red*.txt etc.
Sep
24
comment How to determine which app is stealing (listening on) keystroke / key combination (Windows)?
Drat! Well, thanks for the update anyway. Maybe try contacting the author of that tool and see if they can help? Doesn't look as though anyone else has any insight.
Aug
12
comment How to edit the header of a huge CSV file in-place?
So why mark this down and accept the same answer above?
Jun
30
comment How to focus WEB-browser with a hotkey in Windows?
Shame you felt the need to downvote my answer then!
Jun
16
comment Gaming blew fuse and causes funny smell: how to overcome?
You should be fine - do you have a library somewhere near where you could borrow a power meter? That'll show you for sure.
Jun
13
comment Is there a way to make Notepad++ auto-complete words on {TAB} instead of {ENTER}?
Tab is 10 and Enter is 9
Jun
13
comment Is there a way to make Notepad++ auto-complete words on {TAB} instead of {ENTER}?
I've added appropriate screenshots
Jun
13
comment Synchronizing e-mail using one IMAP and one POP client
IMAP doesn't actually REQUIRE that, it is simply the normal operation. Nothing stops you removing the emails whenever you like.
Jun
13
comment Batch script to mass rename by modify date
Why does needing to run often block the use of software? Do you mean that it will be run on lots of computers? I also assume this is Windows?
Jun
13
comment Sync issues with IMAP and Outlook 2013
It seems that the combination of full moon and sunspots is causing a downvote-fest. Can downvoters please add comments as to why otherwise people can never improve their answers.