Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating To Find A File
I want to add functionality to a user form which allows a user to navigate
through the folder structure and selects a file. I wish to invoke this procedure on a button push. A while a go, and this is where my memory dims, I am sure I had some form of easy way of doing this, but for the life of me I cannot recall accurately. I wish to see some for of windows Explorer-like interface appear. I seem to recall either com API calls were involved or some custom functions. Can anyone help my failing memory? PWS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating To Find A File
Wishes granted for a limited time only. Now, if this were Access we'd have a lot more fun. But this is Excel, so it's pretty simple:
Private Sub CommandButton1_Click() Dim strMyFileToOpen As String Dim strMyFileToSave As String strMyFileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt") strMyFileToOpen = Application.GetSaveAsFilename("Text Files (*.txt), *.txt") End Sub "Paul W Smith" wrote: I want to add functionality to a user form which allows a user to navigate through the folder structure and selects a file. I wish to invoke this procedure on a button push. A while a go, and this is where my memory dims, I am sure I had some form of easy way of doing this, but for the life of me I cannot recall accurately. I wish to see some for of windows Explorer-like interface appear. I seem to recall either com API calls were involved or some custom functions. Can anyone help my failing memory? PWS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating To Find A File
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigating | Excel Worksheet Functions | |||
Navigating | Excel Worksheet Functions | |||
navigating with the tab key | New Users to Excel | |||
CTRL Find is preventing me from navigating around my worksheet | Excel Discussion (Misc queries) | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) |