BorlandTalk.com

Tom Woodrow · Guest

Hope that this is the correct group.

I load CSV files into TStringGrid (or TAdvStringGrid). This works great
unless the CSV file is already opened in EXCEL. If this happens I get
error that I can't seem to trap with try/catch.

What is the best way to verify that a CSV file is NOT already opened in
EXCEL before attempting to open with string grid?

Thanks
Tom Woodrow

Vladimir Stefanovic · Guest

I'm not sure how to check if it's opened by EXCEL
but I know how to check if it is opened by some
other program.

Look at:
http://tinyurl.com/75nlq

There is a routine IsFileOccupied(). Also this routine
must be executed after checking if file exists, etc...

--
Best regards,
Vladimir Stefanovic
"Tom Woodrow" <tomwoodrow (AT) comcast (DOT) net> wrote

Tom Woodrow · Guest

Vladimir,

Thanks for the suggestions. First I use FileExists to verify the file
than use the IfFileOccupied routine from the URL you sent me. I opened a
file with EXCEL and then tested it with IsFileOccupied (below) and get
the EFOpenError exception. It works ok and returns false if the file is
not opened. For some rason the try/catch mechanism is not working here.

Any suggestions?

Thanks
Tom Woodrow

bool IsFileOccupied( const char* s )
{
try
{
TFileStream *tStream = new TFileStream( AnsiString( s ),

fmOpenRead|fmShareExclusive );
delete tStream;
return( false );
}
catch ( const Exception& )
{
return( true );
}

}

Vladimir Stefanovic wrote:

Vladimir Stefanovic · Guest

Tom Woodrow · Guest

Vladimir,

OK, from the IDE it works properly. Is there any way to get it to work
within the IDE also.

Thanks
Tom Woodrow

Vladimir Stefanovic wrote:

Heinrich Wolf · Guest

"Tom Woodrow" <tomwoodrow (AT) comcast (DOT) net> schrieb im Newsbeitrag
news:42f4fe39$1 (AT) newsgroups (DOT) borland.com...

Vladimir Stefanovic · Guest