Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting non-supported files using Excel.Open
Hi, I'm using the Excel Ojbect Library 10.0 (the version which comes
with Office XP) and i'm opening user selected Excel files using Excel.Open(). However, there is the chance a user will select a non-Excel file to be opened. Is there a way to programmatically determine when this occurs so that I won't go through with the processing of the file? In testing, when I select one of these non-Excel files, a dialog pops up saying I've opened an unsupported file, do I want to continue . . . I've tried putting the Excel.Open statement in a try/catch (in C#), however it seems the program blows by the dialog box and continues to open the file even though it's unsupported. Which is weird . . . when debugging, I get the dialog but when I'm not debugging and just running the exe alone, i don't get the dialog. Any ideas? Thanks, Alfred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
Not detecting Open Workbook - Why | Excel Discussion (Misc queries) | |||
Not Detecting Open Workbook Status - Odd?? | Excel Discussion (Misc queries) | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Detecting if a Window/Workbook is Open | Excel Discussion (Misc queries) |