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

IT Consultant

Web Links:


1d
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!
1d
answered How can I convert a PDF document to a Publisher document
1d
answered Heading number and title on separate lines with different styles in office 2013
1d
answered Onenote move page macro
1d
answered I can not fix the incorrect time on my router
1d
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?
2d
answered Pad a number with prefix zeros no and decimal place in Excel?
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
29
answered Can't boot after hardware upgrade
Oct
29
answered Safe to charge USB devices while doing other power-consuming tasks?
Oct
28
answered apt-get fails with raspberry pi although ping works
Oct
28
answered Showing messages from sub-folders in parent-folder with Thunderbird
Oct
28
answered Batch files to combine multiple files (that have parentheses in their names)