Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Folder
What code should I write to open in a box like the
File\Open a specific folder? Thanks PEdro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Folder
Try this:
CAMINHO = Application.GetOpenFilename("Worksheets (*.xls), *.xls", , "SELECCIONE OS FICHEIROS", , True) If VarType(CAMINHO) = 11 Then MsgBox "NĆO FORAM SELECCIONADOS FICHEIROS", vbCritical End If If you want the user to select olny one file change True to False. Note that CAMINHO will be a array type variable if the user select a file. Hope this help. Joao -----Original Message----- What code should I write to open in a box like the File\Open a specific folder? Thanks PEdro . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Fileopen folder | Setting up and Configuration of Excel | |||
Open a Folder | Excel Discussion (Misc queries) | |||
VBA - open folder | Excel Discussion (Misc queries) | |||
Open Excel files in a folder | Excel Programming | |||
open all files in a folder and ... | Excel Programming |