Fix - VBScript

Overview

The Fix command in VB Script corrects the pointer to the currently active Automation server or control. It releases the existing pointer and recreates it, ensuring a valid connection between the script and the target object.

Syntax

objVariable.Fix

Options/Flags

None.

Examples

' Fix the pointer to an existing Excel application
Dim xlApp
Set xlApp = GetObject(, "Excel.Application")
xlApp.Fix

' Create a new instance of Internet Explorer and fix the pointer
Dim ieApp
Set ieApp = CreateObject("InternetExplorer.Application")
ieApp.Fix

Common Issues

• Invalid pointer: Occurs when the target object is closed or unloaded, resulting in a dangling pointer. Running Fix will recreate the pointer, resolving the issue.
• Automation errors: If an automation error occurs during object manipulation, Fix can help reset the connection and resolve the issue.

Integration

Combine Fix with other VB Script commands to automate complex tasks:

' Use "Wait" to pause the script before fixing the pointer
Wait 1000
xlApp.Fix

Related Commands

• CreateObject: Creates a new instance of an Automation server.
• GetObject: Retrieves an existing instance of an Automation server.
• Set: Assigns a variable to a specific object.