Author: Andreas Plahn

How to convert url text to clickable hyperlink in Excel?

How to convert url text to clickable hyperlink in Excel?

Supposing you have multiple urls in your worksheet, but they are not linked, and now you need to convert all the unlinked urls to clickable hyperlinks, as following screenshots shown. Of course, you can double click them one by one to make them clickable, but this will be time consuming if there are lots of urls. How could you convert multiple unlinked urls to clickable hyperlinks automatically in Excel?

via How to convert url text to clickable hyperlink in Excel?.

More tips:
http://stackoverflow.com/questions/2595692/how-do-i-convert-a-column-of-text-urls-into-active-hyperlinks-in-excel

Getting EPiServer 6 r2 drag and drop fileupload to work in Internet Explorer 11 / Windows 8

Make sure you have UAC disabled and running IE as administrator:
http://world.episerver.com/FAQ/Items/Installing-ActiveX-Controls-in-EPiServer-Client-Components-on-Windows-Vista/

Inspiration links:
http://world.episerver.com/Forum/Developer-forum/EPiServer-CMS-6-CTP-2/Thread-Container/2011/8/Problem-with-Advanced-File-Upload—wont-work/

http://world.episerver.com/Forum/Developer-forum/EPiServer-CMS-5-R2/Thread-Container/2012/8/I-cant-get-the-drag-n-drop-component-to-work/

http://blog.fredrikhaglund.se/blog/2008/07/22/installation-of-episerver-components/

Solution:
Go to this folder:
C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Application\UI\CMS\ActiveX

Open the EPiServerClientComponents.CAB file and extract the contents.

Run a cmd prompt as administrator and enter:
cd “C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Application\UI\CMS\ActiveX”
– or wherever you extracted the files

regsvr32.exe EPiFileUpload.dll (install fileupload)
regsvr32.exe EPiOfficeIntegration.dll (install office integration)

Reconnect a network share with credentials on Windows 8 login

Such as the WD MyCloud network disk…

Create a .bat file and enter this:
net use Z: \\192.168.0.2\Document mysecretpassword /user:MyUserName /persistent:yes

Replace text in bold.

Add a shortcut to the bat file to the Startup folder:
C:\Users\[MyUserName]\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup
Set the shortcut to run in “minimized window” to avoid showing the window.

Technet info for NET command:
http://technet.microsoft.com/en-us/library/bb490717.aspx