PRJ4: Changing Paste Linked Cell Via a Macro May Cause GPF

Q128708

The information in this article applies to:

SYMPTOMS

When you attempt to change the value of an object's property (for example, a field such as Task Name) in a Visual Basic for Applications macro, and if the property is the destination of a paste link, you may receive a general protection (GP) fault.

Changing the value of linked information usually results in the message:

Field contains linked data, Okay to remove entire link?
If you choose the No button in this dialog box, you receive a GP fault.


WORKAROUND

To work around this problem, use the SetTaskField method to change the contents of a field that is the destination of a paste link.

NOTE: If you are using the SetTaskField method and you receive the "Field contains linked data" error message, if you choose the No button, you receive the error message:

Run time error '1004' Method failed
To avoid this error, include the "On Error Resume Next" statement in the macro.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post more information here in the Microsoft Knowledge Base as it becomes available.


REFERENCES

For more information about the SetTaskField method, choose the Search button in Visual Basic Reference Help, and type:

SetTaskField


MORE INFORMATION

Additional query words: error hang crash external remote gpf

Keywords : kbcode kbprg kbofficeprog
Issue type :
Technology :


Last Reviewed: March 29, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.