Navigation

1/29/2014

Error: Program cant start because MSVCR80.dll is missing

Error: "Program cant start because MSVCR80.dll is missing..."



Go to Control Panel > Add or Remove Programs (Win XP) or Programs and Features (later)

Remove all of these items in the following order:
  • iTunes
  • Apple Software Update
  • Apple Mobile Device Support (if this won't uninstall press on)
  • Bonjour
  • Apple Application Support

Reboot, download iTunes, then reinstall, either using an account with administrative rights, or right-clicking the downloaded installer and selecting Run as Administrator.



The uninstall and reinstall process will preserve your iTunes library and settings, but ideally you would back up the library and your other important personal documents and data on a regular basis.
https://discussions.apple.com/message/24620553#24620553

To get the DLL file:  http://www.msoutlook.info/question/369 

Also good step by step directions from about.com

1/17/2014

Create hyperlinks in Excel

To create hyperlinks in an Excel column, use the macro below:


Public Sub Convert_To_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
If Cell <> "" Then
ActiveSheet.Hyperlinks.Add Cell, Cell.Value
End If
Next
End Sub

Creating the Macro

  • Open your Excel doc
  • Open the macro editor by pressing ALT+F11.
  • In the Tools Menu, left-click View and select Project Explorer.
  • Look for the folder called ‘Modules’, right-click it, select ‘Insert’, then select ‘Module’.
  • Paste the code into the project module you have selected.
  • Press ALT+F11 to return to your Excel workbook (or click on its icon in the Windows taskbar).

Run the Macro

  • To execute the macro, select the unclickable text links you want to convert to clickable hyperlinks.
  • Press ALT+F8 to open the Macro selector window and click on the macro you just created.
  • Your Links are now all Clickable! Saving you time and data entry fatigue :)

Note:  must save this as extension XLSM, because it has macro (xlsx is non macro enabled spreadsheet)

From:  http://www.niallflynn.com/random-news/convert-urls-to-clickable-links-in-excel/

1/14/2014

Resource Icons in Innovative Webpac


To update material type icons in an Innovative Webpac, need to get to WWWoptions file and change  IMAGE_MATTYPE

There is one for each type, ending with the material type code letter:
IMAGE_MATTYPEp    /screens/media_print_text.png     (CSdirect documentation)

From Sierra, here is screen capture:






One trick, the icon for ERM (Licensed Resource) is not here.

That is separate, goto Icon Resource under alphabetic list of WWWoptions:

ICON_RESOURCE   <img src="/screens/media_erm_text.png" alt="Licensed Resource">