Notes

I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all. How can I record macros for Autohotkey? Answer Unfortunately, the original archive is gone after Autootkey moved to GitHub . However we are lucky that archive.org still has a copy: https://web.archive.org/web/20150908182356/http://www.autohotkey.com/download/AutoHotkey.zip There also once was an alternative named Macrorecorder.com, but this page now is flagged by Mozilla/Google as being taken over by malware. Unfortunately John T's answer is only half of the solution. AutoScriptWriter is no more part of the newest AHK Installer. It is only part of the full old version of AHK, called by the somewhat misleading name "AutoHotkey Basic". Go to the download page http://www.autohotkey.com/download/ Find "Installer for AutoHotkey Basic" If you do not need UniCode, you can install this one, it includes AutoScriptWriter . However I recommend to use the new AHK, so this is

I have Firefox 3.6 installed on my OS X (10.6) box. I would like to open an URL in the running Firefox instance (in a new tab or window, no matter) from the command line. I tried several ways, neither switches -new-tab , -new-window , -url , or none helped me. I always get the A copy of Firefox is already open. Only one copy of Firefox can be open at a time. error message. Answer running open http://www.superuser.com from the command line will (at least for me) open a new tab to superuser.com in firefox (which is my default browser)

I have a few computers connected through a Gigabit router which show 1Gbps connections. However, one of the computers only shows 100Mbps connectivity even though it is capable of 1Gbps. I am not seeing any errors in the event viewer. Computer Specs Windows XP SP3 x86 A8N-SLI Premium MoBo AMD Athalon Dual Core 4400+ CPU (4gigs RAM) Marvell Yukon 88E8001/8003/8010 PCI Gigabit Ethernet Controller Driver: Marvell v11.24.3.3 (2/15/2010) Networking Specs Question 1: How can I configure the above computer/Ethernet Controller to run at 1Gbps connectivity like the others? Update with 2nd Question Question 2: If I were to use the onboard NVidia nForce Networking Controller (currently disabled), which driver should I use the NVidia nForce4/500 series - Windows 2000/XP v6.86 ? (I have an nForce 4 Mobo). NVidia nForce archives: Answer If you've tried forcing the driver to connect at GigE and it fails, you may have a bad (or poor quality) cable. You indicate you have other computers that wo

USB is a popular standard and I was wondering whether there is some way to connect two or more computers using USB ports rather than the Ethernet ports. Answer Yes you can, but you need a specialized USB peripheral known as a USB bridge. A Standard A-to-A type cable would fit the connectors but it would damage your port and could even damage your power source. USB.org used to describe this in their FAQ but is not currently available. They do however list the official spec but it's very technical: https://www.usb.org/document-library/usb-type-ctm-bridge-specification-v11 What the special cable does is provide a chip in the middle that acts as a USB Host, and then again, as a USB peer. This site shows such cable. Combining this with a USB Hub you could create a small LAN, but it´s definitively not the way to do it, as Ethernet would have more performance and be cheaper. Some suggestions already been provided, here is another one with pricing: http://www.datapro.net/products/usb-2-

I have an error while just copying a video with ffmpeg. I use the command: ffmpeg -i leon.mpg -vcodec copy -acodec copy leon2.mpg The errors: [mpeg @ 00000000020ebd20] max_analyze_duration 5000000 reached at 5004000 microseconds [mpeg @ 00000000042f4020] buffer underflow i=0 bufi=11286 size=14824 [mpeg @ 00000000042f4020] packet too large, ignoring buffer limits to mux it What do I have to set that the buffer errors don't occur anymore? Here is a picture of what ffmpeg gives out first. After that the red errors repeat really many times. There you also can see what the film's codec and so on is. See this picture: I use the ffmpeg Version git-5ce023b (2013-01-15) - Win64 - static build from Zeranoe. I tried some things but nothing happened. I searched a while but found no solution. Answer I have also had this problem, my workaround was to use a different format, example $ ffmpeg -i leontest.mpg -c copy -v warning leon2.mp4 [mpeg @ 000000000209bd40] max_analyze_duration 5000000

I'm trying to use my Samsung WEP470 bluetooth headset with Windows 7 for VOIP apps. When I try to "Add a Bluetooth Device" in the control panel, it detects the headset and installs a driver. However, at the end of driver installation, I see the error message, "This device cannot start. (Code 10)" I've deleted the WEP470 profile and uninstalled the driver several times. Every time I try to pair it again, the profile is created and Windows 7 starts installing the driver, but fails at the end with the Code 10 error. I'm using the Microsoft Bluetooth transceiver that came with my Microsoft IntelliMouse Explorer for Bluetooth, and the mouse works fine. From other Superuser.com posts, it looks like the headset should just work, as long as I have the Bluetooth transceiver's drivers properly installed. Any ideas what I'm doing wrong? Answer I've found the problem: my old Microsoft Bluetooth adapter apparently didn't support the version of the B

An HP Pavilion dv7 laptop will not boot, or even post. It does power on briefly (fans spin up, LEDs come on) when the Power button is pressed, but it does not beep/post or display the bios. Instead it almost immediately turns off again. The person who last used this laptop reported sparks going off when the keyboard was touched. It does the same thing no matter what I've tried, including: long pressing the power button using just the battery plugging in the the charger and removing the battery removing both RAM chips removing a CMOS battery Possibly related questions: Answer Holding down the power button for more than 10 seconds resolved the issue. The laptop now boots again. Technically I'm not really sure what that did, but I'll take it!

With ssh -i you can instruct ssh to use an extra private key to try authentication. The documentation is not clear on how to explicitly use only that key. Answer You can use the IdentitiesOnly option: ssh -o "IdentitiesOnly=yes" -i

What is the quickest tool that can let me choose a rectangle (of a predefined size) within any picture file, and it should crop it to that. Something like the tool you get when uploading a Gravatar ... remember? Typical image editing software like Paint.NET or Photoshop is too slow, you have to open the image file, select a rectangle manually, crop, save, close ....

How do I run as a different user on a shortcut in Windows 7? On Windows XP, I had the ability to mark a shortcut as being run by a different user, so that every time I ran it it would prompt me for a username/password. This let me have two shortcuts for things like SQL Server Management Studio , one for my normal account and one for my domain administrator account which has access to production servers. I can get to the 'Run as different user' option with Shift + right-click , but I can't see an option anywhere that would let me mark the shortcut as doing this every time. Answer Right-click > New > Shortcut For Target, type "runas /user:domain\user program.exe" I think you can replace "domain" with the computer name if you want it to use a local account. http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/windows_security_runas_shortcut.mspx?mfr=true The link above is for XP, but I was able to do this in Windows 7. Whe

I have one folder whose view options I would like to set for "Large Icons". For another folder, I want to set its view options for "Details". Unfortunately, it seems I can only set it globally. Is there a way to set view options for individual folders? OS: Windows 7 Ultimate 64bit

Alt and AltGr usually work well but sometimes, for no reason they stop working. Restarting the computer doesn't work. I checked the keyboard language. I checked if I have one of these programs running in the background (List of known programs blocking Altgr): -Remote Desktop Connection -Windows XP Mode (Virtual PC) -EasyTune -VMWare vCenter -mRemote -VirtualBox -Ditto -Unknown wmp (winamp?) plugin -Visual Studio 2010 (an add-in perhaps?) I have a 2015 Acer Aspire with Windows 8.1 Is anyone aware of a different problem that can cause this symptom?

When working with multiple instances of Notepad++, each with its own set of files opened, and the OS crashes then Notepad++ seems to be only remembering one single instance and not the rest. Is there any way to instruct it, perhaps with a plugin, to remember all opened files of all instances so that in case of a crash they can all be recovered and not just a single window? Answer Take a look at notepad++ Session management: Sessions are a set of files opened in Notepad++. They store the open files, the active file (and which view, see the section about Multi-View), the current selection and position in the file, the current bookmarks (see Bookmarks) and the current language (see the section about Languages). Using sessions, you can open a set of (related) files with one action. You would have to manually save your sessions at regular intervals or use some kind of macro to automate this ... unless you install the Session Manager plugin The Session Manager Plugin adds aditional featur

Hey everyone. This is my first post here, I wasn't sure if it should go on stack overflow or here, but this seemed like the best option. The question is pretty straightforward. Can I embed a youtube video in an HTML email? I did a quick test and it didn't work. Would it be dependent on the mail client? Let me know if anyone has a solution to this. Thanks. Answer Yes, it would depend mostly on the client. Even if you manage to get the correct tags to the client, it may not have Flash enabled, or it may not show embedded objects. The other part is their mail server, which may sanitize HTML before sending or storing it. But few do that.

I think I found the problem to my Windows 7 Reboot Loop when it goes to configure from a Windows Update (it stops at 32%). Even when I choose Safe Mode which says it is reverting the Windows Updates. I'm not 100% sure but it could be my UPEK Fingerprint driver. There was a recent release of an update for it, and Windows Repair Disc did a scan and, though it couldn't fix the issue, the results stated that a driver error was not letting windows startup. So, once I'm in the Windows (R) aka Windows Repair I have the option to load up Command Prompt. I can then access my Windows Drive which for some reason got assigned to D: instead of C: ... my question is: Normally if I want to remove a driver I go to Start>Control Panel>System, click on the device and remove it (the driver get's removed). What is the equivalency of this in the Command Prompt? Answer Driver Information is stored in the registry HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services You could use the

Note: I know there are several seeming duplicates for my question, but I have tried the suggestions in all of them with no luck as, in almost every case, I do not have the setting/file/tab/etc suggested! Like many other Windows 10 users my touchpad (and mouse buttons) disable when typing. This is obviously completely undesirable as a gamer as it makes most games impossible. I would really appreciate a fix to this, be it in my computer or by downloading some kind of software or program that can fix it. Specs Sager NP8952 Notebook (approx 1mo old) Windows 10 Home, version 1709 Synaptics SMBus TouchPad Symptom When holding down keys on the keyboard, the computer does not register touchpad or mouse button input One - Disable PalmCheck, SmartSense, etc My laptop does not have a "ClickPad", "Synaptics", "DeviceSettings" or other touchpad-specific settings tab in the mouse page. Please see below: Any guide saying to disable settings in the mouse pane won't w

The FAQ of GTA IV tells me to turn off Windows Event Log in msconfig . This will handle the game more efficiently. And it does! But turning off windows processes always worries me. So therefore: After playing GTA IV. Should I turn on Windows Event Log again? If so: What does it do? If not: Why is it booted by windows in the first place? Answer I find it surprising and shocking that Rockstar would actually recommend disabling the Event Log. It’s not just some extraneous service that most people don’t use, it’s a required service that Windows expects to be running, and frankly I would be surprised if you don’t get a crash at some point if it is disabled. (It’s like trying to run Windows with the RPC service disabled: you might be able to do it for a bit, but expect a BSOD soon.) Besides, the Event Log does not normally cause any sort of performance problem whatsoever (it is normally idle unless a relevant event has been generated), so if GTA IV actually gets bogged down when it’s run

I have 4 desktops running Windows Server 2008 32bit version. I created some shares in all these machines. My program gets files from these machines (like \machine1\abcd ). The machine names mentioned in the program and the actual machine names doesn't match and I can't change either program or machine names. So I mapped the machine name used by the program to the local IP address of the machine using "hosts" file. Everything works fine, but, when I try to access a share in a machine using local machine's name, Windows asks for a username and password. (I tried entering username and password but its not working). But when I try to access the same share using local machine's IP address, its opening. Let my machine names be m1 , m2 , m3 , m4 and my program refers to them as mb01 , mb02 , mb03 , mb04 . When I try to access a share in mb01 from mb01(m1) as \\mb01\share1 , Windows asks for username and password. When try to access shares in other machines everythi

As more and more websites add paste blocking code of one type or another to e-mail and password fields and more people use password managers, the two are increasingly coming into conflict. While there are extensions such as Don't fuck with paste for Chrome or Disable clipboard manipulations and the dom.event.clipboardevents.enabled preference † for FireFox, all of these suffer the problem that there are legitimate reasons why websites might want to hook into onpaste (such as Google docs rich text support or Facebook's link handling) so I don't want that functionality completely disabled. † Go to about:config and search for dom.event.clipboardevents.enabled then double click to toggle. Another option is to hack every page you find with the offending code manually, but that is a lot of hassle and doesn't work in every case (such as with this page ). One suggestion of how to do this can be found on Martin Brinkmann's Paste Passwords into blocked form fields on

My question is: why overclocking the RAMs does not bring a significant performance increasing? If I speed up their frequency and/or their latency, I will not get big advantages. I can't understand it, considering that the CPU should be able to read and write faster as well as processing data. Or maybe the bottleneck is getting smaller because of faster CPUs? Please give me as much information as you can. Regards. Answer Because in most general-purpose cases, RAM speed is not the bottleneck for a system. What difference is a few nano seconds going to make when it takes more than six million nanoseconds to pull the data off of the harddrive in the first place? This is one of the reasons I stopped doing manual overclocks on much of my hardware. It simply doesn't make enough of a difference where it matters. Hopping into the BIOS for a few seconds and telling my motherboard to boost the CPU frequency by 30%? Alright, that's noticeable. Spending hours and hours of repeated r

Sometimes the image of the mouse pointer will get corrupted. I can still use the mouse but because the image is corrupted it is somewhat difficult. How can I get the mouse pointer back without logging out? Edit: I noticed that the mouse corruption goes away when VMPlayer is shut down. Answer Go to System/Preferences/Appearance ,and choose Theme tab,then click Customize... and choose pointer tab,here you can choose the mouse pointer type(or image as you said?).

A few days ago I installed Centos 7 on my server and run ssh. Now I want to track logs. Is there anyway to combine cat or tail with grep to have clear failed and accepted login attempts list from a chosen day? I know it won't work, but something like: cat /var/log/secure | grep "Accepted" "Failed" "Today's date" Answer Just: grep '^\(Accepted\|Failed\) date' /var/log/secure or: grep -e Accepted -e Failed /var/log/secure | grep date

We have an ASUS Zenbook UX305FA laptop running Windows 10 that is able to be woken from sleep with an external Keyboard and Mouse when they are plugged-in directly into their individual USB ports. However, after plugging in a USB Hub and then plugging the external Keyboard and Mouse into the USB Hub, the laptop will no longer wake up from sleep with the external Keyboard or Mouse. It only wakes up if the built-in laptop keyboard is pressed. However, as this laptop is being used as a Desktop, the laptop lid is kept closed at all times, which is why we need to be able to wake the laptop using the external keyboard and mouse. We need the other USB ports on the laptop to be free, which is why we need to plug the mouse and keyboard via the USB Hub. In Device Manager, the "Power Management" settings for both the external Keyboard and Mouse are set to "Allow this device to wake the computer" under "Keyboards" and "Mice and other pointing devices", res

I have a Mac tower which has two Ethernet ports. One is connected to our corporate network, the other to a non-corporate network. Priority order states that the non-corporate network comes first and thus all traffic is routed through that. I'm looking to add a route so that anything on our corporate sub net is routed through en1 vs en0 . First, how do I find what the coporate subnet is? Second, how do I add this properly as a route? Third, I have MS communicator that I would like to route its traffic through en1 as well, how do I do that? Answer The answer to the first two questions should be ask your corporate IT person . If you really need to do it yourself then open a command prompt and check the output of these commands: ifconfig (shows the IP addresses you are using) netstat -rn (shows the defined routes) The third question is a bit harder. You wrote that Priority order states that the non-corporate network comes first . I assume this means the default gateway is set to t

On my HP Compaq 6710b there's an internal WIFI network adapter. Attached to the same laptop there's also an external USB Alfa WIFI adapter. I live near campus and can pick it's WIFI signal. The problem is that when I am connected to the Internet Wifi using the internal adapter, and then connect to the home (non-internet) Wifi network's router, I lose the connection to the internet (it stays connected, but there's no actual connection). So how can I use the two adapters to connect to both networks successfully ? The router is Belkin N150 Enhanced Router Model F6D4230-4 V1 The external adapter is: ALFA AWUS 036NHR

often I need to create proposal documents for customers which have many common elements. For example, I have the following sections of text: Company Introduction Information about Product A Information about Product B Information about Product C etc... I'd like to present a popup to the user on opening the document which allows them to tick the relevant sections which would then be added to the document (or the irrelevant sections removed). I'm looking for the simplest way to create this. I'm thinking of two possible approaches: Add each section as quick part, and somehow have the tick box automatically add the right quick part at the end of the document. Create the whole document with all sections and somehow remove sections automatically if not required. I've been searching for a while but no luck. Any pointers would be good. Ideally I'd like to do this without any coding, but if that's not possible anything simple considered that is easily maintainable. Thank

In linux, ls -l lists files permissions, like this: -rw-r--r-- 1 user user 924 2011-07-01 20:23 test.txt In Windows, commands tree and dir don't have the options to list permissions. How is it possible to list files and their permissions using command line only? Answer Use icacls : > icacls Music Music SNOW\grawity:(I)(F) CREATOR OWNER:(I)(OI)(CI)(IO)(F) SNOW\grawity:(I)(OI)(CI)(IO)(F) NT AUTHORITY\SYSTEM:(I)(OI)(CI)(F) The older cacls tool is the only choice on Windows XP [although you can copy icacls.exe from Server 2003]. cacls does not know about some ACL modes, but displays most of them fine. > cacls Music F:\Users\Mantas\Music SNOW\grawity:F CREATOR OWNER:(OI)(CI)(IO)F SNOW\grawity:(OI)(CI)(IO)F NT AUTHORITY\SYSTEM:(OI)(CI)F In both outputs, (OI) means "object inherit" (files will inherit this ACE), (CI) is "container inherit" (containers – i.e. folder

I am using Windows 8.1 and I believe that it's been infected. I wanted to format it but I haven't backed up the files . will upgrading to windows 10 remove the virus ? Or is there any other way I can get rid of the virus..?

I want to use ext4 on my external HDD, but it must be cross-platform. (At least Linux, Win7 & WinXP). Unfortunately, I haven't found any proper driver allowing Windows to WRITE to ext4. I've found Ext2Fsd , but it only reads ext4. 9. ext4 extent read-only, no size truncating and expanding support More: Supported Ext3/4 features: flexible inode size: > 128 bytes, up to block size dir_index: htree directory index filetype: extra file mode in dentry large_file: > 4G files supported sparse_super: super block backup in group descriptor uninit_bg: fast fsck and group checksum extent: reading, writing with no extending. journal: only support replay for internal journal Unsupported Ext3/4 features: journal: log-based operations, external journal extent: size truncating & expanding, file deletion flex_bg: first metadata group EA (extended attributes), ACL support Also, I have found a patch for Ext4Fsd v0.50 ( here ): New: Matt Wu has made a new release 0.50 at ext2fsd.com

I have Windows XP installed in dualboot with Ubuntu, how can i remove the ubuntu installation and go back to only XP Answer If you've installed Ubuntu Linux from within Windows using Wubi , you can just remove "Ubuntu" from Add/Remove Programs. However, if your linux installation is on a different hard disk partition, you need to 1. use a partitioning software to remove the linux partition(s), and 2. restore the Windows boot loader. Windows has Disk Manager somewhere in the Control Panel to remove partitions. At least with Windows XP, you can restore the Windows boot loader by running the command fdisk /mbr , or from a Rescue CD with the commands fixboot and fixmbr . Note that the linux boot loader depends on the linux parition, so if you remove the linux partition without touching the boot loader, you won't be able to boot your computer without a rescue CD.

I've been running into a problem where some of the applications from the startup menu don't actually start upon login. After looking at the list of the applications I've noticed that actually only the exe files that I've set in properties to "Run as administrator" (in compatibility tab) don't run (and also a .cmd file). How do I run those apps during startup? Answer Use the good old Task scheduler approach to start applications with elevated rights at startup. start Task Scheduler and create a new task mark the checkbox "Run with highest priviligies" under action point to the exe you want to run give the task a name and save it create a new shortcut C:\Windows\System32\schtasks.exe /RUN /TN "MYTASKNAME" copy this shortcut into the startup folder There is also a tool called UAC Pass which does all the steps for you.

Writing slashes appear displaced usually in word. What is the best way and most visually appealing to write a slash and how to adjust the position of the slash. https://en.wikipedia.org/wiki/Feynman_slash_notation symbol combined with unicode 0338 gives something unpredictable Ctrl F9 and inserting a field 'eq \o (here,/)', can work also unpredictably but I cannot adjust its advanced features.

The title pretty much explains it ... Anyone knows of any screen capture programs which offer a feature to upload the result to imageshack, or some similar site, and gives an URL, so it can be quickly used when composing webpages, or answering questions on SO/SU ? Answer The best, hands-down, is Jing .

One of our work steps involves saving an MS Excel worksheet as CSV and then using UltraEdit to convert the CSV to UTF-8 before importing it into a server system. The problem is that, after the conversion to UTF-8, the file always contains 3 nonsense characters at the start of the file: ENTITY_ID;FIELD2;FIELD3,FIELD4;(etc.) value1;value2;value3;value4;(etc). Observations: As you can see, there are 3 characters that are noise and cause the server to reject the CSV import because the first column is not named "ENTITY_ID". The characters are always the same. These characters are not shown after the conversion, but when we close and reopen the file in UltraEdit again, then we do see the characters. These characters are only visible in UltraEdit. Windows Notepad or Notepad++ does not show them. Using Notepad++ to convert the CSV to UTF-8 produces the exact same output: a file with the same 3 odd characters in the beginning. The only difference is that Notepad++ does not display

I tried to export some variable. I create file .bash_profile and put inside export SPRING_PROFILES_ACTIVE=local After it I reboot my ubuntu, login, but nothing happens. My system is fresh ubuntu 18.04. What I do wrong? Answer Probably not what you're looking for, but I don't believe .bash_profile exists. Try adding that export command to .profile instead. Aka, echo "export SPRING_PROFILES_ACTIVE=local" >> .profile (Tested on Debian Stretch; I don't use Ubuntu, but the fact you said "I create .bash_profile " is odd)

I use a command line tools under windows 10. The path to the tool is set in the system PATH variable so that it can be started from the command line. Whenever a new version of the tool comes out, I store it to a new directory and update the system PATH to point to the new location. Restart the command window and everything is fine, the new version of the tool is used. After a ahutdown and start however, the PATH reverts back to the old value and the old version of the tool gets used. Opening the envoronment variable editor and clicking OK, without making any changes, solves the problem ... until the next shutdown. I have searched the whole registry, the old PATH value is nowhere found. It must be stored somewhere else. After some time, (I guess after a windows update gets installed, but I am not sure about this) the problem goes away and the new PATH value is remembered. In previous windows versions this worked without problems, I see this behaviour only after upgrade to Windows 10. Ho

To give a concrete example, how does OSX choose which of these default entries from netstat -nr to route to? Destination Gateway Flags Refs Use Netif Expire 0/1 10.10.99.100 UGSc 0 0 ppp0 default 192.168.1.1 UGSc 5 0 en0 default 192.168.1.1 UGScI 1 0 en1 default 192.0.2.1 UGScI 157 2 ppp0 From what I have been able to tell OSX uses metrics on its interfaces rather than on its routing table entries. But by default all of those interface metrics are 0 so how does it choose? Last created interface? I've seen some folks suggest its the order in the Network preferences, but in my case the ppp0 interface (from SonicWall NetExtender) isn't listed there. There is some discussion in this thread , but no answer that I see. Answer Most systems follows these rules when choosing which route to use: F

I'm trying to map: Super+h -> Left Super+j -> Down Super+k -> Up Super+l -> Right globally under X. The idea is I don't want to leave my home row that often to use the arrow keys, so I'll use the Super modifier + hjkl to emulate the arrow keys under X. Is there any way to do this? One thing I've tried is xbindkeys + xte using this configuration: "xte 'keydown Up' 'keyup Up'" Mod4+k "xte 'keydown Down' 'keyup Down'" Mod4+j "xte 'keydown Left' 'keyup Left'" Mod4+h "xte 'keydown Right' 'keyup Right'" Mod4+l but there seems to a large delay between me pressing the key and noticing any result, and most of the time nothing happens at all. Is there a more elegant way of doing this that actually works with no delay?

I am wiring up my home using CAT5e cable. Before committing to the cables I have created, I have plugged them in (uncrimped) and they are not working. Do I need to take the plunge and crimp the cables before I can test them? I was hoping to wire up first and buy a crimping tool later this week. Apologies if this is an obvious question, I couldn't seem to find this information anywhere.

Is it possible to use SkyDrive on Windows 8.1 without using a cloud account? I tried switching to a cloud account but it screwed up authentication between my PCs as they rely on identical user names and passwords on each device. Answer Use the tool syncDriver to add SkyDrive to win8.1 when you use a local account:

Let say I have the following values in the cells A1 : `=Now()` which displays 17.03.2014 13:45 A2 : 12.03.2014 Both are in date format and I have the function in another cells like this: B1 : `=TEXT(A1;"dd.mm.yyyy")` B2 : `=TEXT(A2;"dd mm yyyy")` In the first case I received a #VALUE Error in the cell In the second case I received : dd 03 yyyy like only the month is working. I am under Windows 7 and Office 2013 Professional. Any guess what it could be? Answer Your code works fine for me. Although I have to use B1 : =TEXT(A1,"dd.mm.yyyy") B2 : =TEXT(A2,"dd mm yyyy") I am guessing the reason I use , instead of ; is due to the difference of language. The fault is more likely to be due to dd.mm.yyyy For example, I know in Germany, I can't use dd because d (day) in German is tag, and as such it requires tt I'm guessing the month is fine, based upon your dd 03 yyyy ... Switzerland uses many languages I think and so I have no idea what

I have a device (for example, a music player or a TV) that has a USB port and will read files off a thumb drive and play or display them. Is there a way connect that USB port to a PC and in software on the PC serve up files to a virtual drive that would then be recognized by the music player or TV as present in its USB port? I assume that this would have to be a combination hardware and software for the reasons described in this question . Does anyone have a solution for this? Answer What you need is something similar to a USB data copy cable. The problem is that data copy cables just use custom software on both ends to manage the copy - they don't actually make anything look like a drive. You need custom software on the PC end, and then enough brains in the middle to pretend to be a USB drive. If you were up to reverse-engineering one of those copy cables, you might be able to use it as the basis for what you want, but you'd have to write all of the software yourself.

Computer files aren't actually removed when they are deleted on Windows. The address pointer is simply released and that space freed for overwrite later. For sensitive information, it is recommended that you erase it with a scrubber that obscures the file first. It turns out that these scrubbers write a specific sequence of 1's and 0's to the hard drive over several iterrations. Why can't you just write all zeros or all ones to the file and then delete it normally? How could someone manage to recover data from a straight wipe like that any more or less than using multiple iterations and patterns? Answer The short version: theoretically , the original pattern can still be read by certain sophisticated hardware and software. To ensure the security of your "erased" data, it must be wiped. The long answer: http://en.wikipedia.org/wiki/Data_remanence Edit: In fairness to those that have already voted, I'm leaving my answer as originally written; however, do r

I used to be able to type start \\other_machine\c$ in PowerShell and Windows Explorer would pop up with a login dialog. Then I'd type other_machine\moswald and my password (the account is a local admin, of course) and I'm in. Now both machines have Windows 8 installed, and this no longer works (the dialog re-prompts with an "Access is denied" displayed). I've verified (through whoami ) that the user is named other_machine\moswald , and I'm positive I'm typing the correct password. So what gives? Note : This is without a domain.

So I have had an external hard drive connected to my laptop, and have been writing millions of files to the external hard drive. One directory even has over 2 million folders at the first level deep. Probably a dozen times my computer has frozen up. I have about 50+ windowed applications opened and every now and then my screen gets that nintendo glitch look to it where everything turns to lines and shakes. The glitching part doesn't cause the freezing, but something is causing it. When it freezes the spinner goes on forever and I have to press the power button to shut it off. I leave it shut off for at least 15 seconds before turning it on again. When I start again, it gives me back all my windows as they were, except the terminal windows aren't in the right spot anymore, they're just at the home directory. I say all this because now I can't even type ls inside /Volumes , it just hangs. I tried hard unplugging the hard drive and plugging it back in. It registers in the

Through the CLI (either cmd.exe or PowerShell) on Windows 7, how do I edit the TCP/IP DNS parameters for a specific network adapter? Answer netsh.exe netsh interface ip set dns name="Local Area Connection" source=static addr=none netsh interface ip add dns name="Local Area Connection" addr=8.8.4.4 index=1 netsh interface ip add dns name="Local Area Connection" addr=8.8.8.8 index=2 netsh interface ip set dns name="Local Area Connection" source=dhcp

In Windows 7, is it safe to delete desktop.ini files from my destkop? (I have 2 hidden desktop.ini files in my desktop) Answer Yes it is. Here is an explanation of what they are for.

My macOS device detects and connects to the wifi signal from a router that is 20 m away. My Windows computer with a USB dongle and my Raspberry Pi can see the signal but cannot connect to it. Why the difference in range from the different devices? In the meantime, I set up an old modem as a range extender of sorts . Answer Antennas of different size and shape have different gain ratios and different reception patterns. For example almost all antennas will have a dead-zone. For whip antennas it is a cone originating from the top and bottom of the antenna. Typically this results in a donut or toroidal shaped antenna pattern. Patch antennas can have a much more directional pattern that "blasts" out in almost every direction from the patch except behind it. Antenna length affects the gain of the antenna, and in turn high gain antennas have smaller or more focused beams. A high gain whip antenna will be able to transmit and receive further, but will have a much narrower (in th

The most annoying thing I have found in Windows by far is when it automatically lowers the volume to the point where someone cannot hear me, just because I coughed or sneezed. It then never raises the volume, causing me to have to manually adjust the volume every couple minutes, which is really annoying. What I am talking about is: Windows Logo > Control Panel > Hardware and Sound > Manage Audio Devices > Recording > "device" > Levels > Microphone It constantly lowers the volume and I wish it wouldn't. This happens when I use MSN only. How do I fix it?

I'm looking for a way to override DNS entries in Firefox, for development/testing purposes. I know the normal way to do this is via the hosts file, but I cannot edit it since I don't have admin access on my work machine. Does anyone know of a browser plugin/addon which would do this for me? I did find the SwitchHosts add-on , although it also requires admin rights in order to install itself.

Are they in the registry or in some folder? Answer Generally to remove or configure these tray icons you'll need to open the application itself and configure the "show in system tray" option if there is one.

I've built a minimal Linux for my BeagleBoard xM (Rev C) using the Yocto project build appliance, and installed it on a uSD card following their instructions. It works (Yay!), has a small footprint and boots really fast which is what I want. I used a pretty minimal build recipe with this in mind. It gives lots of encouraging messages about loading drivers for the USB devices. However, when I log in, there is no ethernet interface, and nothing else on the USB seems to work. I've tried plugging in a USB memory stick but it's not recognized (nothing appears in log shown by "dmesg"). I don't get anything on the display, either - I am interacting over the serial port console. I'm using the u-boot binary built by Yocto, and loading the device table (dtb file) and kernel image from the same source. However, I noticed that the (working) Debian image I have also includes an "initrd" image. Borrowing from the Debian boot environment, I was able to load tha

After the latest windows 10 update,my mouse for no reason keeps disconnecting and reconnecting and also it makes windows usb unplug/plug sounds.This is so annoying,I can't even play a game correctly.My right arm hurts from this.. Someone told me that I need to reinstall its drivers..but I m not really sure,what to do.I would appreciate some help ASAP. Mouse : Logitech M90

I have two machines, A and C, each of which is behind a firewall so they can’t accept incoming SSH requests on port 22. I have a third machine, B, outside both firewalls and I wanted to SSH from A to C using B. I am able to do what I think is called an SSH tunnel from C -> B like so ssh -fNR 10000:localhost:22 -i key_file_for_B_on_C user_on_B@B Following what looks like the almost what I want on this question I now try the command: ssh -ti key_file_for_C_on_A -l user_on_C -o "ProxyCommand ssh -ti key_file_for_B_on_A -W %h:%p user_on_B@B" -p 10000 B That doesn’t seem to work, I get the error: channel 0: open failed: connect failed: Connection timed out Is this the right approach? What might I be doing wrong? Answer I think the problem with your example is the final arguments; you are ssh ing to B, when you should be listing the "final destination" , albeit the port-forwarded host/port, which is port 10000, but should be localhost , not B , as B is resolved fro