General information
Category:
Coding, syntax & commands
You could check the status of the activeworkbook after opening:
?oExcel.ActiveWorkbook.Readonly
or before opening:
?oExcel.Workbooks.CanCheckout(fullpath(file_name))
Though I do not know how to get the user name by whom the file is locked.
>Not sure what you mean. I am using the following code..
>
>oExcel = CREATEOBJECT("Excel.Application")
>oExcel.Visible = .T.
>oBook = oExcel.Workbooks.FOPEN(xlFile)
>oSheet = oBook.ActiveSheet
>
>and it will allow me to open it and write to it even though it is ReadOnly. I want to prevent this from opening until someone else is done using it.
Previous
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