[Solved] Make folders and files using excel vba macro and display with tree view and hyperlinks

I think that should do the trick. This macro will take folder path from cell A1 and list recursively its contents and subfolder contents with hyperlinks. Update: fixed, now it’s working. 🙂 Public Position As Integer Public Indent As Integer Sub ListFileTree() Position = 0 Indent = 0 Call RecurseFolderList(Range(“A1”).Value) End Sub Private Sub ClearFormatting(Rng … Read more

[Solved] Build hierarchy type presentation of data in Excel

Try this, it makes use of a temporary PivotTable… Option Explicit Sub TestMakeTree() Dim wsData As Excel.Worksheet Set wsData = ThisWorkbook.Worksheets.Item(“Sheet1”) Dim rngData As Excel.Range Set rngData = wsData.Range(“Data”) ‘<—————– this differs for me Dim vTree As Variant vTree = MakeTreeUsingPivotTable(ThisWorkbook, rngData) ‘* print it out next to data, you’d choose your own destination Dim … Read more

[Solved] Show folders/files in TreeView ( VB.NET 2008 )

Please search first before ask again and again This ‘Don’t forget to import this Imports System.IO ‘Declare these Private Enum ItemType Drive Folder File End Enum Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load For Each drive As DriveInfo In DriveInfo.GetDrives Dim node As TreeNode = _ file_view_tree.Nodes.Add(drive.Name) node.Tag = ItemType.Drive … Read more

[Solved] How to amend (e.g. add/remove) the values of a ttk.Treeview tag (tkinter)?

According to the tcl documentation, a ttk.Treeview widget does have commands to add and remove a tag from a node or a list of nodes. However, these methods are not provided in the official tkinter wrapper; see the Treeview class in /usr/lib/python3.8/tkinter/ttk.py. Building on the comment by @JasonYang and answer by @CoolCloud, the test code … Read more

[Solved] VB.NET 2008 Not recognizing Path.GetFileName Method

‘Don’t forget to import this Imports System.IO ‘Declare these Private Enum ItemType Drive Folder File End Enum Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load For Each drive As DriveInfo In DriveInfo.GetDrives Dim node As TreeNode = _ file_view_tree.Nodes.Add(drive.Name) node.Tag = ItemType.Drive node.Nodes.Add(“FILLER”) Next End Sub Private Sub file_view_tree_BeforeExpand(ByVal sender As … Read more

[Solved] GtkTreeView set selection to specific row

You don’t need to use a GtkTreeIter for this, the GtkTreePath API is enough. You’re throwing your path away before using it, which creates problems. Here’s how to do it: GtkTreePath *path = gtk_tree_path_new_from_indices(3, -1); gtk_tree_selection_select_path(treeview_selection, path); gtk_tree_path_free(path); UPDATE: I rewrote the code completely to drop use of GtkTreeIter, I originally thought that you wanted … Read more

[Solved] WPF C# Bind multiple treeViewItems isSelected to tabItem isSelected

using SelectedValue and SelectedValuePath. The TreeViewItem child and parent must have the same Uid. <Window x:Class=”WpfApp1.MainWindow” xmlns=”http://schemas.microsoft.com/winfx/2006/xaml/presentation” xmlns:x=”http://schemas.microsoft.com/winfx/2006/xaml”> <StackPanel> <TreeView x:Name=”treeView” Height=”200″ SelectedValuePath=”Uid”> <TreeViewItem Header=”Letters-1″ x:Name=”tab1″ Uid=”Letters-1″> <TreeViewItem Header=”a” Uid=”Letters-1″/> <TreeViewItem Header=”b” Uid=”Letters-1″/> <TreeViewItem Header=”c” Uid=”Letters-1″/> </TreeViewItem> <TreeViewItem Header=”Letters-2″ x:Name=”tab2″ Uid=”Letters-2″> <TreeViewItem Header=”d” Uid=”Letters-2″/> <TreeViewItem Header=”e” Uid=”Letters-2″/> <TreeViewItem Header=”f” Uid=”Letters-2″/> </TreeViewItem> <TreeViewItem Header=”Letters-3″ x:Name=”tab3″ Uid=”Letters-3″> … Read more