Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement