General information
Category:
COM/DCOM and OLE Automation
Title:
How can I check if excel File is open before writing to it?
I have code that reads binary data (an embedded excel spreadsheet) from a sql server table using an ADODB.Stream. Then it writes the excel data back to the users local drive.
However, if the user chooses an excel filename to save to, and that file is already open in excel, I get an Ole error.
I can check for this with my error handler, and if the write fails just close the stream and tell the user that the file is already open. However, my question is, is there anyway that I can test if the file is already open, without generating an error and without using error handling code
A portion of the code is below
omstream.Type = adTypeBinary
omstream.Open()
ovalue=ors.Fields("FILECOL")
omstream.Write(ovalue)
omstream.SaveToFile(lcFileName, adSaveCreateOverWrite)
omstream.close()
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only