Tag: microsoft

How to Remove Auto-Publish from Excel Documents

February 11, 2015 /

How to Remove Auto-Publish on Excel 2007

by Kirk Bennet, Demand Media

You can use Microsoft Office Excel 2007 to create documents for Web publication. Excel also comes with an option to automatically publish the document whenever you change it. However, there are cases where you may not need the auto-publish feature, so you need to disable this feature. To accomplish this, you must save the document to get access to the auto-publish setting where you can disable it. You can also disable auto-publish for all other documents you have published in the past.

Step 1Launch Microsoft Office Excel 2007 and open the spreadsheet you want to remove the auto-publish feature from.

Step 2Click the “Office” button in the top-left corner of the Excel 2007 window.

Step 3Click “Save As” in the resulting menu.

Step 4Select “Web Page” in the Save As Type drop-down box.

Step 5Click “Publish” and the Publish As Web Page window pops up.

Step 6Remove the check-mark from the “AutoRepublish Every Time This Document Is Saved” option in the Publish As section to remove the auto-publish feature.

Step 7Click “Choose” and select “Previously Published Items” to start disabling auto-publish for more documents.

Step 8Select each document with the feature still active and click the “Remove” button.

Step 9Click “Close” to close the window.

Step 10Press “Ctrl” and “S” to save your spreadsheet.

 Tip
  • Select the “Enable AutoRepublish Feature” when you publish the workbook to enable the auto-publish feature.

Reproduced from http://smallbusiness.chron.com/remove-autopublish-excel-2007-40236.html

Windows 7 taskbar not responding

December 29, 2014 /

Click Start

Type: CMD, from the results, right click CMD

Click ‘Run as Administrator’

At the Command Prompt, type: sfc/scannow

This will check for any integrity violations

Restart your system

  1. Insert the Windows 7 DVD
  2. Restart your computer
  3. When asked if you want to boot from your DVD drive, do so.
  4. Choose your language, click Next.
  5. Click ‘Repair your computer’
  6. Select operating system you want repair.

LDAP Active Directory User Object Properties/Attributes

July 28, 2014 /
LDAP Active Directory Properties/Attributes
LDAP Property Description
DN DN Stands for distinguisehd name. This is the unique identifier for any object in AD. An example value would be:

CN=Joe User, OU=Las Vegas, DC=mycompany,DC=com

Note that when identifying a DN value in your script you will likely be required to enclose the line above with double quotes (“) so it would look like this:

“CN=Joe User, OU=Las Vegas, DC=mycompany,DC=com“
CN CN = Joe User
CN stands for Common Name. This property is a combination of the givenName and SN attributes joined together
displayName displayName = Joe User
Note that displayName and CN are often confused for each other.
description Note that this is different from displayName
givenName The first name of the user
homeDrive Home Folder
name name = Joe User. The same as CN
ObjectClass objectClass = User
Identifies what type of object is selected. Other values are: Computer, orgnizationalUnit, container, group
objectCategory objectClass = Person
Defines what schema category that object belongs to.
physcialDeliveryOfficeName The office field of the user property
profilePath Roaming profile path: connect. Setup is a bit tricky
sAMAccountName sAMAAccountName = jUser
This is an old NT 4.0 logon ID. This value must be unique in the domain.
SN SN = User
This is the last name of the user. SN stands for surname
userAccountControl This property is used to enable or disable a user account. A value of 514 means that account is disabled. A value of 512 means the account is enabled.
userPrincipleName userPrincipleName = juser@lasvegas.com
This property is useful for logging in a large forest Active Directory architecutre. This is also a unique property throught the forest. This property is often abbreviated as UPN.
mail mail = juser@lasvegas.com
the email property of the user
C Country or Region
company Name of Company or Organization
department Department
homephone
l Location. Used mainly with printers
That is a lower case (L)
manager
mobile Cell phone or mobile phone number
OU Orgnizational Unit
postalCode Zip or post code
st State or province
streetAddress Street address, not including country or state
telephoneNumber Office Phone
dNSHostName
rID
url
uSNCreate
uSNChanged
tokenGroups A computed attribute that contains the list of SIDs due to a transitive group membership expansion operation on a given user or computer. Token Groups cannot be retrieved if no Global Catalog is present to retrieve the transitive reverse memberships.

More Info

.NET Active Directory – Understanding LDAP Active Directory User Object Properties/Attributes.

How to get security updates for Windows XP until April 2019

May 28, 2014 /
Written by  on May 24, 2014 in Windows – Last Update: May 24, 2014 36
Article reprinted from ghacks.net

Microsoft’s official support for the Windows XP operating system ended more than a month ago. While some companies and organizations are still receiving updates for the operating system, end users do not.

 These companies pay Microsoft for that, usually because they were not able or willed to migrate computer’s running Windows XP to another operating system before the extended support phase for the system ended.

There is another exception to the end of support rule: Windows Embedded Industry, formerly known as Windows Embedded POSReady, operating systems continue to receive updates.

What makes this interesting is the fact that Windows Embedded POSReady 2009 is based on Windows XP Service Pack 3, and that the security updates released for that system are identical with the ones that Microsoft would have released for XP systems.

The extended support for Windows Embedded POSReady 2009 systems ends on April 9th, 2019 which means that you can use the trick to get another five years of security patches for XP.

windows xp updates

What you cannot do is go ahead and install those updates as you will get a version mismatch error when you try to do so. There is however a trick that you can use to bypass those checks so that you can install those updates on your version of Windows XP.

Note: The trick works only for 32-bit versions of Windows XP SP3 and not 64-bit versions. While POSReady systems are very similar to Windows XP systems, it is recommended to back up the system before you make any changes as differences between the systems may result in issues after installing updates designed for it.

All you need to do is add the following to the Windows XP Registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\WPA\PosReady]
“Installed”=dword:00000001

I have uploaded a Registry file for you that you can use for that purpose. You can download it here: xp-security-updates.zip (6039 downloads)

If you prefer to create one on your own do the following:

  1. Create a new plain text document.
  2. Paste the contents displayed above into it.
  3. Save the new document as xp.reg.
  4. Double-click the Registry file afterwards to add the contents to the Registry.

Alternatively, open the Registry Editor manually: tap on Windows-r, type regedit and hit enter. Navigate to the key listed above and create a new Dword with the value listed there as well. (via Desk Modder and Sebijk)

Both source sites are in German. If you open the Sebijk site, you will also find instructions on how to get this to work on 64-bit Windows XP systems. It involves running a batch file that replaces original update files with temporary ones that bypass the restrictions set in place.

Closing Words

If you are running Windows XP and do not want to switch to a new system or cannot, then you may want to try this trick to install security patches designed for the POSReady 2009 operating system on your PC.

I recommend highly that you create a backup before you update the system as there is no guarantee that all updates will work properly on XP PCs. While POSReady 2009 uses the same core, some things are different after all.

Nevertheless, this is better than not installing any security updates.

Article Name:  How to get security updates for Windows XP until April 2019
Author: Martin Brinkmann
Description: Support for Windows XP ended April 2014. but there is a trick that you can make use of to get security updates for the operating system.

Generate Random String

December 3, 2013 /

randomstring

 

Imports System.Text
 
Public Class Form1
 
  Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim s As String = “ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz”
    Dim r As New Random
    Dim sb As New StringBuilder
 
    For i As Integer = 1 To 8
      Dim idx As Integer = r.Next(0, 61)
      sb.Append(s.Substring(idx, 1))
    Next
 
    TextBox1.Text = sb.ToString
  End Sub
End Class