Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
What is the object of embedding, what is it used for? | New Users to Excel | |||
Embedding in a cell. | Excel Discussion (Misc queries) | |||
Error Embedding Row() within Indirect() | Excel Worksheet Functions | |||
Embedding a Hyperlink | Excel Discussion (Misc queries) |