Excel-DNA / Excel-DNA/IntelliSense
Add tip resources from VBA code comments and other features suggestions.
- Dominant language
- C#
- Stars
- 179
- Forks
- 55
- PR merge metrics
- No merged PRs in 30d
Description
it seems Intellisense tip have 3 types of resources
1) external xml file with $workbook.name$..IntelliSense.xml
2) built-in xml part inside workbook using Workbook.CustomXMLParts.Add strXMLContent
3) worksheet with a name of "_IntelliSense_"
i have found two problems
1) when tip resources updated then tips will not auto-update
maybe we can add a callback function to update tip resources by hand.
2) when the external and built-in xml resource does not exist, the worksheet("_Intellisense_") resource seems not load
which seems like a bug
and i have suggestions like below
1) maybe we can add a new resource, which read from VBA IDE.VBE code comments
'@FuncDesc:A function described by vba comments
'@Param1:FirstArg As Variant
'@Desc1:this is for FirstArg
' and this for FirstArg too
'@Param2:SndArg As Long
'@Desc2:this is for SndArg
Function MyVbaFunction(FirstArg, SndArg)
MyVbaFunction = FirstArg + SndArg
End Function
2) when four types of tip resources all on
i think the tip load priority can be like this: vba comments -> worksheet -> external xml -> built in xml
because vba comments and worksheet data can be set and update more conveniently.
3) maybe we can add a callback function to set custom tip data like this.
Sub GetTipString(byref strTipContent as string)
strTipContent = ReadTextFile("c:\1.xml")
End Sub
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.