Open Folder
What code should I write to open in a box like the
File\Open a specific folder? Thanks PEdro |
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 . |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com