Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following macro segment is supposed to detect if the user
cancelled out of an "Open File" input window, but I keep getting a "subscript out of range" error. What am I doing wrong? Dim FName As Variant FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If Not FName = False Then Workbooks.Open FName Application.DisplayAlerts = False If FName < False Then Set wb = Workbooks.Open(FName) MsgBox "File open cancelled" wb.Close End If Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
cancel the "Getting Started" Dialogue Box when I open XL/Word | Setting up and Configuration of Excel | |||
input box - I don't need the "cancel" button | Excel Programming | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming |