MISSING:refrence

Dossfm0q

Banned User
Joined
Mar 9, 2009
Messages
570
Office Version
  1. 2019
Platform
  1. Windows
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-com:eek:ffice:eek:ffice" /><o:p></o:p>​
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:p></o:p>

Is there code can do ?
<o:p></o:p>
Thanks
<o:p></o:p>​
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,122,436
Messages
5,596,106
Members
414,042
Latest member
Swiftkoala

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top