Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I used the VB Example code from Microsoft Help but wanted to select MULTIPLE files and have Option Explicit declared. The error trapping no longer worked properly for no file being selected n the dialog box- can someone give me a hand in getting it to work. Thanks Tim Option Explicit Sub ImportBudgetFileData() Dim FileToOpen FileToOpen = Application _ .GetOpenFilename("Text Files (*.xls), *.xls", , , , True) 'If FileToOpen(1) < False Then ' MsgBox "Open " & FileToOpen 'End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trapping errors in a VLOOKUP function | Excel Worksheet Functions | |||
Trapping errors with Conditional Formatting | Excel Discussion (Misc queries) | |||
Trapping Workbook OPEN errors | Excel Programming | |||
annoying bell when trapping errors | Excel Programming | |||
Remind me to set Error Trapping to Break on Unhandled Errors | Excel Programming |