Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Project References
Dear all,
I encountered a great problem while dealing with the references in Excel VB project. I have some operations to perform every month. Since the operation detail will always change in a unpredicatble way, I decide to backup the entire directory to some archive locations. To resolve the XLA absolute path, I write some VBA code to localize the XLA in the backup directory. Dim refList As References Dim ref As Reference Set refList = oWorkbook.VBProject.References For Each ref In refList If ref.Name = "ABC" Then refList.Remove ref End If Next Set ref = refList.AddFromFile("Location of ABC to be archived.") MsgBox ref.FullPath What I encounter is that the AddFromFile() does not work at all if the addin "ABC" is opened. Do anyone have idea on that? Thanks a lot. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Cannot save Project file as MS Access file | Excel Discussion (Misc queries) | |||
Missing library when running 98 project on 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |