Posts

Showing posts from November, 2012

Distorted cell display in Excel 2010

Image
Problem : MS Excel cells are wrong or distorted like on the picture below. It have been seen on different computers with different files while scrolling or copy-pasting. Solution : terminate the ipoint.exe process  and configure the system to not load ipoint.exe upon startup (using msconfig or regedit).

PowerPoint crash when scrolling through slides (kernelbase.dll or oart.dll)

Image
Problem: Microsoft PowerPoint 2010 may crash while you are copypasting slides or scrolling through them in Slide Sorter view. If you check the Application log in the Event Viewer, you may find something similar to this record: Faulting application name: POWERPNT.EXE, version: 14.0.6009.1000, time stamp: 0x4cc1a4ed Faulting module name: KERNELBASE.dll, version: 6.1.7601.17651, time stamp: 0x4e211319 Exception code: 0xe0000002 Fault offset: 0x0000b9bc Faulting process id: 0x5a8 Faulting application start time: 0x01cdc3cbb1c20f5b Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\POWERPNT.EXE Faulting module path: C:\WINDOWS\syswow64\KERNELBASE.dll Report Id: 484578ef-3244-11e2-88e2-0026b9efd81c Solution : First of all make sure that it happens only to the specific presentation file. Then go to the master and check if you have any graphical elements in it. They are generating 99% of the problems. In my specific case it was Windows Metafile object tha

How to change additional drivers printer defaults on the server

Imagine a situation: you have Windows 2003 x86 server working as a print server and you have a bunch of Windows 7 x64 machines that uses network printers installed on the server. If you need to change printing defaults for Windows 7 machines you cannot do that on the server because only x86 driver settings are availble. To change defaults for Windows 7 64 bit clients you need to: Open a share \\servername from Win7 machine (using admin credentials) Click on the "View remote printers" Right click on the printer name> Properties> Advanced tab> Printing defaults… Change everything you need and click OK If you are just want to know how to update x64 printer drivers on the x86 print server then you should definetely use Print Management console on your Windows 7 x64 system.

Xerox 116-324 fault when printing .doc or .pdf containing callibri fonts

Image
Problem : You are unable to print .PDF or .DOCX documents which contain Calibri fonts. The Xerox 7345 or similar model sends 116-324 error code and needs to reboot. Resolution : Update you computer with the latest drivers from Xerox website. If you are on PCL driver - disable the Print Optimization feature in the driver. If you are on the PS driver set the PostScript Output Option to Optimize for Portability. The print file will be larger and printing will take more time. Another PS driver setting may screw up the text in your PowerPoint slides (as shown on the picture below). It is "PostScript Pass-through". If you have printouts like on the picture below, you better enable "PostScript Pass-through" (Printing preferences> Advanced> Driver section. )

How to enable guest profile printing in Windows

By default Guest user account settings to be reset after restart. It forces user to install printer each time after computer reboots. But user from local Guest group wants to have default printer installed. Solution: Workaround is to have default printer set up for every user on the machine by default. Make sure to backup your registry before making any changes. The Default User profile is created when Windows is installed. The first time a user logs on to a workstation, the default user profile is copied to the user profile. Therefore, only new users are affected by changing the Default User profile as described here. To add a default printer for all new users: 1. Log on with the Administrator account and install the appropriate default printer. 2. Start Registry Editor (Regedt32.exe). 3. Locate the following key: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\Current Version\Devices Note the information for the value of the key that represents the default printer t

How to change Analysis toolpack language

This is a common problem for corporate multilanguage environment. If you have Analysis toolpack (Excel 2010> Data tab> Data analysis) in your native language and you want to set it back to english do the following: Remove your old add-in: msiexec /i \\SERVER\Share\Excel.en-US\ExcelMUI.msi REMOVE=ExcelAddinATPFilesIntl_1033 Install the English version: msiexec /i \\SERVER\Share\Excel.en-us\ExcelMUI.msi ADDLOCAL=ExcelAddinATPFilesIntl_1033,ExcelAddinSolverFilesIntl_1033

Outlook Anywhere grayed out

The Outlook Anywhere feature, formerly known as RPC over HTTP, lets clients that use Microsoft Office Outlook 2010, Outlook 2007, or Outlook 2003 connect to their Exchange servers from outside the corporate network or over the Internet using the RPC over HTTP Windows networking component. If you are unable to select "Connect to Microsoft Exchange using HTTP" checkbox or "Exchange Proxy Settings..." button is grayed out it is most likely that these settings are blocked by group policy (Article 961112 Policy Setting). If you can't change the GPO by yourself there is another option: you can change registry setting. It will be overwritten with the next gpupdate, but at least you can setup your mailbox and start working. So start, regedit and browse to: HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\outlook\RPC and Change ProxyServerFlags  to 1

How to modify (change) multiple Outlook itmes (contacts or appointments) at a time

Question : How can I modify (change) multiple Outlook itmes (contacts or appointments) at a time? Solution : The easiest way to do this is to select an existing view that corresponds to the changing field. For example, if you’re changing the Company field in Contacts, then you’d click By Company in The Current View section of the Navigation Pane. If Outlook doesn’t have a view for the field you want to change, you can create it yourself: Choose View, Current View, Define Views. The Custom View Organizer dialog box displays. Click New. The Create a New View dialog box displays. Use the Name of New View text box to name the view (for example, By Field, where Field is the name of the field you want to modify), make sure Table is selected in the Type of View list, and then click OK. The Customize View dialog box displays. Click Group By to display the Group By dialog box. In the Group Items By list, click the field you want to modify. Click OK to return to the Customize View dial

How to remove shared Outlook folder

Problem : When trying to close shared Outlook mail folder the following error appears: "This group of folders is associated with an e-mail account. To remove it, on the Tools menu, click E-mail accounts, select View or change e-mail accounts, click Next, and then click Remove" or "This group of folders is associated with a mail account. To remove it use the 'E-mail Accounts' command on the Tools menu." Solution : Open the registry editor, and go to: HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Default Look through each of the folders below that to find which ones is causing the particular mailbox to be opened, then delete that whole folder This issue has been seen in Microsoft Outlook 2007 and Outlook 2010 N.B.:  Sometimes your AD schema may still contain the additional mailboxes info and that result in recreating registry records when Outlook restarts. If this is the case go into ADSIEdit.msc and drill d

Macros to send all emails from Drafts folder at once in Outlook

There is sometimes a need to send all draft emails at once. To do this: Start Outlook and choose Tools, Macro, Visual Basic Editor (or press Alt+F11) to open the VBA Editor. In the Project window, select Project1 and expand the tree until you see ThisOutlookSession. Select ThisOutlookSession and press F7 to open the Code window. Enter the following in the Code window: Public Sub SendDrafts() Dim lDraftItem As Long Dim myOutlook As Outlook.Application Dim myNameSpace As Outlook.NameSpace Dim myFolders As Outlook.Folders Dim myDraftsFolder As Outlook.MAPIFolder 'Send all items in the "Drafts" folder that have a "To" address filled in. 'Setup Outlook Set myOutlook = Outlook.Application Set myNameSpace = myOutlook.GetNamespace("MAPI") Set myFolders = myNameSpace.Folders 'Set Draft Folder. This will need modification based on where it's being run. Set myDraftsFolder = myFolders("Personal Folders").Folders(&q

VBA script to modify all Outlook Calendar items

Using the script below you may automate the process of putting birthdays in your calendar. This is the 2 step process. First - you import your birthdays list from .xls file to Outlook calendar and second - you run the script to make all appointments to be recurring. So this script will modify all (multiple) Outlook Calendar items to be rucurring yearly: Sub replacement()  Dim Ns As NameSpace  Dim MyCalendar As MAPIFolder  Dim Item As Object  Set Ns = GetNamespace("MAPI")  Set MyCalendar = Ns.GetDefaultFolder(olFolderCalendar)  Set srtitems = MyCalendar.Items     For Each Item In srtitems  DoEvents    Set myRecurrPatt = Item.GetRecurrencePattern     myRecurrPatt.RecurrenceType = olRecursYearly     Item.Save  Next End Sub

How to delete blocked file

Problem : Windows says 'file access denied' when trying to delete a file.  'File in use' error. Can't delete a file. Rebooting doesn't help to delete the file. Solution : Some files need to be locked down when they are in use, otherwise you risk damaging the file or harming the Operating System. Unfortunately Windows XP seems to be plagued by files that cannot be deleted. These are frequently simple files like videos (AVI), MP3s or other seemingly harmless files. You try to delete the file, Windows waits a few seconds before announcing that access is denied, the file is currently in use and cannot be deleted. However, you know it's not in use and you just want it deleted. If you have encountered this problem, here is a step-by-step process for trying to purge the files you can't delete. It starts with the basics for Windows XP and moves on to more involved tricks. The process will work for all recent Windows releases, but Windows XP has been causing

How to unblock .chm file downloaded from the Internet

Question : I've downloaded .chm file from the Internet. However, when I open the file, I get the message "Navigation to the webpage was canceled". Solution : You also can't download .chm files from a web browser and simply click Open.  Download the .chm file to your computer first, right-mouse click it in Windows Explorer and select Properties.  Then click Unblock.

How to type cyrillic characters on the latin keyboard

Question : I've bought a laptop with latin keyboard only. How can I setup translit keyboard to type Ukrainian characters? Answer : Download the file uatrans.zip from this link, unzip it and run Setup.exe. This will install ukrainian translit keyboard on your machine. Works for Win XP, Vista, 7.

"Start" button isn't working in Windows 7

Symptoms : Start menu couldn't be opened neither by clicking Start button nor by hitting Ctrl+Esc / WinKey. Also running programs are not shown in the taskbar. Solution: This is the common situation when you had virus infection and some files have been damaged during the clean-up process. You may play with the registry and/or use third-party software, but the most reliable and the fastest way to resolve this is by performing full scan of your computer for viruses and then creating a new user profile. You can then copy My Documents, Desktop etc. to the new profile. Your old user profile even if recovered may not work stable in future.

Create Outlook calendar item with Python

I've created this script when I needed to keep track of my street workout performance. I was needed to have a reminder for each day that will tell me how much repetitions I should do today. So this script will create a bunch of Microsoft Outlook appointments in your calendar according to the "table" dictionary. The table is reduced for this example. It is easier to create such table in MS Excel, then convert it to text and paste into your favourite Python IDE. Please note that this code is using PyWin32 library. def addevent(start, subject):     import win32com.client     oOutlook = win32com.client.Dispatch("Outlook.Application")     appointment = oOutlook.CreateItem(1) # 1=outlook appointment item     appointment.Start = start     appointment.Subject = subject     appointment.Duration = 20     appointment.Location = 'Sprortground'     appointment.ReminderSet = True     appointment.ReminderMinutesBeforeStart = 1     appointment.