View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Papergal Papergal is offline
external usenet poster
 
Posts: 4
Default Embedding Indirect.ext

I have a workbook that uses indirect.ext. The spreadsheet can be accessed by
anyone in my company, so I embedded the indirect.ext in the spreadsheet.

I get the following error in the VB program when the sheet is opened...
Compile error: Can't find project or Library. It highlights "space" in the
following code:

For Each A In AddIns
If A.FullName Like "*\Morefunc.xll" And A.Installed Then
Version = Space(10)
GetPrivateProfileString "Settings", "Version", "0", Version, 10, _
A.Path & "\Morefunc.ini"
Version = Left(Version, InStr(1, Version, vbNullChar) - 1)
If Evaluate(Version) = Evaluate(GetVersion) Then GoTo RestoreSheets
End If
Next

Thanks,