This VBA script will save the text from one column (O) into a file for which the name is taken from column (K).
Surprisingly this method, which opens and closes a file for each row of the sheet is much faster than the method I describe here, which tells Excel to save sheets to file as csv. I presume the overhead is due to Excel having to serialise the sheets to CSV format.
Today I wanted to save every sheet in an Excel workbook as a CSV file, the headings of each sheet is removed first.I got help from the following sources:
Here's the code:
Today I wanted to copy the values from every sheet in one workbook into a new workbook with only the values. Here is what worked for me eventually:
The purpose of this is to save every sheet in a workbook as a CSV file.
The URLs where I found advice were in no order of preference:
DavMail hides the proprietary Microsoft Exchange protocols behind an industry standard API so that any open source client can interact with Exchange. From their website:
DavMail is a POP/IMAP/SMTP/Caldav/Carddav/LDAP exchange gateway allowing users to use any mail/calendar client (e.g. Thunderbird with Lightning or Apple iCal) with an Exchange server, even from the internet or behind a firewall through Outlook Web Access. DavMail now includes an LDAP gateway to Exchange global address book and user personal contacts to allow recipient address completion in mail compose window and full calendar support with attendees free/busy display.
The main goal of DavMail is to provide standard compliant protocols in front of proprietary Exchange. This means LDAP for global address book, SMTP to send messages, IMAP to browse messages on the server in any folder, POP to retrieve inbox messages only, Caldav for calendar support and Carddav for personal contacts sync. Thus any standard compliant client can be used with Microsoft Exchange. DavMail gateway is implemented in java and should run on any platform.
Windows allows you to use shift and a keypad arrow to select words. In Linux the shift keypad arrow toggles numlock and writing a number as described here by xenopeek. Fortunately you can make the keypad and shift work the same as in windows as described here by mvaldez which is:
Go to the System Settings > Keyboard Layout > Layout > Options
Select Miscellaneous / Compatibility options > Shift with numeric keypad keys work as in MS Windows.
Go to the virtual machine folder.
This is how to run a dual boot Windows 8 on Linux Mint / Ubuntu in Virtualbox.Install virtualbox.
Create a virtual machine without a disk.
In Virtualbox attach the new disk to the SATA storage setting.
Start the virtual machine.
Your normal boot menu will show, make sure you select Windows, it might not be a good idea to start the host OS as a guest in itself.
Windows will spend some time detecting new drivers, etc. and then boot up.
If Windows reboot too many times, try using the install DVD's repair function.
Damn XWindows on Linux is unable to scale the mouse sensitivity. Which means that a high sensitivity mouse cannot be used, unless you use the following script which was addapted from this post by Raphael Ahrens.
Once again I realise how slow business managers are in catching up with and grasping the opportunities and risks involved in what is often dismissively called I.T. For example, the testing of IT systems (software, networks and hardware) has never really featured on the CEO's dashboards or at Business College. Yet, it is probably one of the most powerful risk management functions within an organisation. This was recently highlighted, courtesy of Knight Capital and the investigations following their small ($400 million) blunder.
Testing of IT systems is very similar to the auditing of financial books. It is the double entry method for technology systems, first enter the code into the computer and secondly enter the expected results into the tests. No amount of business requirements, system designs, architectures or other documentation can make up for a lack in testing. If your organisation is not prioritising testing over documentation then you are doomed to have high overheads, low returns and unmanageable risks.
It's amazing how low middle management's regard for
their testing resources are and how little they expect of their testers.
I am inspired to see people like Aldo Rall go to great lengths to explain the benefits of proper testing to business and IT management. If you are a senior manager you should understanding how IT gets work done. If you are an IT manager, you should consult with people like Aldo on how to improve your testing division.
My Thinkpad's wireless just wouldn't work in ubuntu even though it worked in Windows, eventually putting some tape on the PCI express connector of the Wifi card did the trick.
Here are a few troubleshooting steps for wifi problems on a Lenovo Edge 13 laptop.
Run all these commands in a terminal.
If you see the above then your hardware is turned on and ready to connect, now you must install and configure the "network-manager" or "WICD" which is not covered here.
Check if hardware is there:
Check if drivers are loaded:
Take a few number(not letters) from the above and see if the driver is loaded:
If the driver is not loaded then you must find out how to compile it.
The radio is turned off by software, run:
go back to 1 and re-test.
Press "Fn-F9" then return to 1 to re-test.
If the button does nothing then check if ACPI is installed:
The above keycode says XF86WLAN which means the correct button has been pressed.
Find the event ID, look for the ThinkPad Extra Buttons event:
Listen for the event ID. Put the above event ID in the command below :
If it is PCI express then put a small piece of tape over pin 20 of the connector as per this discussion.
This person got it working somehow...
Here's a great tutorial on using Phonegap with the ZXing barcode scanner plugin.
The phonegap plugin does not work with Phonegap 1, so the following fixes is required:
Remove line107 from barcodescanner.js: