How to embed a directory explorer within an excel workbook?

[mozzyUK]

Hi, i am trying to, if at all possible, insert a directory explorer within an excel spreadsheet. Similar to inserting a calendar into a spreadsheet.

Has anyone found a way of doing this?

Thanks in advance,

 

[Ivan F Moala]

Re: How to embed a directory explorer within an excel workbo

Hi, i am trying to, if at all possible, insert a directory explorer within an excel spreadsheet. Similar to inserting a calendar into a spreadsheet.

Has anyone found a way of doing this?

Thanks in advance,

The nearest ?? you could come is to insert a Webrowser control
on your sheet.

Then code it something like .........

Sub Tester1()
Dim objWb As WebBrowser

    Set objWb = Sheet1.WebBrowser1
    
    With objWb
        .Navigate ("C:/")
    End With
    
End Sub

Right click the control to select different views