Windows 7 – Fixing The Mapped Drive Credentials Problem

In the Group Policies Editor, open each of the following items in turn:
Computer Configuration
Windows Settings
Security Settings
Local Policies
Security Options
Now, right-click on the “Network security: LAN Manager authentication level” policy item, and then, from the context (pop-up) menu, select “Properties”.
Now select the “Local Security Settings” tab, and then, in the dropdown box, locate and select “Send LM & NTLM – user NTLMv2 session security if negotiated”.

from [url]http://www.gadgetgrill.com.au/2009/11/19/windows-7-fixing-the-mapped-drive-credentials-problem/[/url]

how to disable digital signature in win7

1. bcdedit.exe -set loadoptions DDISABLE_INTEGRITY_CHECKS
2. bcdedit.exe -set TESTSIGNING ON
3. Restart

excel marco google map retreive xml data

modifed for work


Sub getDistances()

Dim xhrRequest As XMLHTTP60
Dim domDoc As DOMDocument60
Dim ixnlDistanceNodes As IXMLDOMNodeList
Dim ixnNode As IXMLDOMNode
Dim lOutputRow As Long

' Read the data from the website
Set xhrRequest = New XMLHTTP60
xhrRequest.Open "GET", "http://maps.googleapis.com/maps/api/directions/xml?origin=address&destination=address&sensor=false", False
xhrRequest.send

' Copy the results into a format we can manipulate with XPath
Set domDoc = New DOMDocument60
domDoc.LoadXML xhrRequest.responseText

' The important bit: select every node called "value" which is the child of a node called "distance" which is
' in turn the child of a node called "step"
'Set ixnlDistanceNodes = domDoc.SelectNodes("//leg/distance/text")

Set ixnNode = domDoc.SelectSingleNode("//leg/distance/text")

' Basic stuff to output the distances
Range("B2").Value = ixnNode.Text



Set ixnNode = Nothing
Set ixnlDistanceNodes = Nothing
Set domDoc = Nothing
Set xhrRequest = Nothing

End Sub

VBA code for retrieving distance between two places from google map

original post: [url]http://stackoverflow.com/questions/3985887/how-can-i-extract-the-distance-from-google-directions-api-via-excel-web-query[/url]

[font=Arial,][size=14px]Sub[/size][size=14px] getDistances[/size][size=14px]()[/size]
[size=14px]Dim[/size][size=14px] xhrRequest [/size][size=14px]As[/size][size=14px] XMLHTTP60
[/size][size=14px]Dim[/size][size=14px] domDoc [/size][size=14px]As[/size][size=14px] DOMDocument60
[/size][size=14px]Dim[/size][size=14px] ixnlDistanceNodes [/size][size=14px]As[/size][size=14px] IXMLDOMNodeList
[/size][size=14px]Dim[/size][size=14px] ixnNode [/size][size=14px]As[/size][size=14px] IXMLDOMNode
[/size][size=14px]Dim[/size][size=14px] lOutputRow [/size][size=14px]As[/size]
[size=14px]Long[/size]
[size=14px]' Read the data from the website[/size]
[size=14px]Set[/size][size=14px] xhrRequest [/size][size=14px]=[/size]
[size=14px]New[/size][size=14px] XMLHTTP60
xhrRequest[/size][size=14px].[/size][size=14px]Open [/size][size=14px]"GET"[/size][size=14px],[/size]
[size=14px]"http://maps.googleapis.com/maps/api/directions/xml?origin=Scoresby&destination=Melborne&sensor=false"[/size][size=14px],[/size]
[size=14px]False[/size][size=14px]
xhrRequest[/size][size=14px].[/size][size=14px]send

[/size][size=14px]' Copy the results into a format we can manipulate with XPath[/size]
[size=14px]Set[/size][size=14px] domDoc [/size][size=14px]=[/size]
[size=14px]New[/size][size=14px] DOMDocument60
domDoc[/size][size=14px].[/size][size=14px]loadXML xhrRequest[/size][size=14px].[/size][size=14px]responseText

[/size][size=14px]' The important bit: select every node called "value" which is the child of a node called "distance" which is[/size]
[size=14px]' in turn the child of a node called "step"[/size]
[size=14px]Set[/size][size=14px] ixnlDistanceNodes [/size][size=14px]=[/size][size=14px] domDoc[/size][size=14px].[/size][size=14px]selectNodes[/size][size=14px]([/size][size=14px]"//step/distance/value"[/size][size=14px])[/size]
[size=14px]' Basic stuff to output the distances[/size][size=14px]
lOutputRow [/size][size=14px]=[/size]
[size=14px]1[/size]
[size=14px]With[/size][size=14px] Worksheets[/size][size=14px]([/size][size=14px]"Sheet1"[/size][size=14px])[/size]
[size=14px].[/size][size=14px]UsedRange[/size][size=14px].[/size][size=14px]ClearContents
    [/size][size=14px]For[/size]
[size=14px]Each[/size][size=14px] ixnNode [/size][size=14px]In[/size][size=14px] ixnlDistanceNodes
        [/size][size=14px].[/size][size=14px]Cells[/size][size=14px]([/size][size=14px]lOutputRow[/size][size=14px],[/size]
[size=14px]1[/size][size=14px]).[/size][size=14px]Value [/size][size=14px]=[/size][size=14px] ixnNode[/size][size=14px].[/size][size=14px]Text
        lOutputRow [/size][size=14px]=[/size][size=14px] lOutputRow [/size][size=14px]+[/size]
[size=14px]1[/size]
[size=14px]Next[/size][size=14px] ixnNode
[/size][size=14px]End[/size]
[size=14px]With[/size]
[size=14px]Set[/size][size=14px] ixnNode [/size][size=14px]=[/size]
[size=14px]Nothing[/size]
[size=14px]Set[/size][size=14px] ixnlDistanceNodes [/size][size=14px]=[/size]
[size=14px]Nothing[/size]
[size=14px]Set[/size][size=14px] domDoc [/size][size=14px]=[/size]
[size=14px]Nothing[/size]
[size=14px]Set[/size][size=14px] xhrRequest [/size][size=14px]=[/size]
[size=14px]Nothing[/size]
[size=14px]End[/size]
[size=14px]Sub[/size][/font]

save number key state after log off

HKEY_CURRENT_USER\Control Panel\Keyboard

   InitialKeyboardIndicators: REG_SZ: NUMBER

   Default: 0

change to "2"

refer to [url]http://support.microsoft.com/kb/123498[/url] and [url]http://support.microsoft.com/kb/102978/EN-US[/url]

disable bitlocker from winPE

Boot from a Vista WinPE disc, or Bart, whatever you want to use.
Then use:[color=Red] cscript manage-bde.wsf -unlock C: -recoverypassword nnnnnn-nnnnnn-nn....
[/color]
Where "nnnnnn" is the 48 digit recovery password for the drive.

unmount wim

dism /Cleanup-wim to coercively unmount images