How to embed a directory explorer within an excel workbook?

mozzyUK

New Member
Joined
Nov 18, 2005
Messages
17
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

MrExcel MVP
Joined
Feb 10, 2002
Messages
4,209
Re: How to embed a directory explorer within an excel workbo

mozzyUK said:
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 .........

Code:
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
 

Forum statistics

Threads
1,077,782
Messages
5,336,284
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top