Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |