Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I disigned several user-defined function and I'd like it
could be automatically installed to others PC, so I need the function to create a "xla" file and use Addins ("abc").installed=True to active it. but I failed. below is my codes, pls help to diagnose. '-------------------------------- Sub LoadXLA() Dim AddInPath As String Const xlaFile As String = "abc.xla" AddInPath = "C:\Documents and Settings\user\Application Data\Microsoft\AddIns\" If Dir(AddInPath & xlaFile) = "" Then WB.SaveAs AddInPath & xlaFile, FileFormat:=xlAddIn End If AddIns("abc").Installed = True End Sub '-------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
"create chart" is not active | Charts and Charting in Excel | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |