View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alexander Fleck Alexander Fleck is offline
external usenet poster
 
Posts: 1
Default Return Value of GetOpenFilename, Excel 2007

hi,

I used GetOpenFilename and checked its return value for
= False

Excel 2003 worked, but
Excel 2007 not

There was a type problem.

If no File is chosen it works, because the return value is False.
But if a valid File is chosen, it throws a type error, because the False of
the check is not a String.

I now convert the return value by using CStr and check it against "False".

is that a known issue?


Besuchen Sie uns auf der Embedded World in Nürnberg, 1.-3.3.2011, Stand
121, Halle 10!

Mit freundlichem Gruß

Alexander Fleck

--
Alexander Fleck
Schleißheimer GmbH
61206 Nieder Wöllstadt
Tel.: 06034 9148 791
Fax: 06034 9148 91
Registergericht: Amtsgericht Friedberg
Handelsregisternummer: HRB 1581
Geschäftsführer:
Hans-Joachim Schleißheimer
Christine Schleißheimer