I have File gets some data from PI Data link (process interface) via server. Reopening this file after log out server some VBA procedure corrupt Like left, right, Mid and Date …els (message can't find project or library )is there other reference, to resolve this problem I uncheck MISSING reference from Reference Dialog witch load automatically when open file with Server Excel manually, then I get Code from web to remove Missing Reference but My try was failed and tel me Object library not register
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
HTML:
[LEFT]Public Sub CheckReference()
Dim vbProj As VBProject ' This refers to your VBA project.
Dim chkRef As Reference ' A reference.
' On Error Resume Next
' Refer to the activedocument's VBA project.
Set vbProj = ThisWorkbook.VBProject
' Check through the selected references in the References dialog box.
For Each chkRef In vbProj.References
' remove If the reference is broken.
If chkRef.IsBroken Then
vbProj.References.Remove chkRef
End If
Next
End Sub
[/LEFT]
<o></o>
Is there code can do ?
<o></o>
Thanks
<o></o>
Is there code can do ?
<o></o>
Thanks
<o></o>