Excel-DNA / Excel-DNA/IntelliSense

Add tip resources from VBA code comments and other features suggestions.

Open
#137 2 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.