ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is this right (open for write access) (https://www.excelbanter.com/excel-programming/310749-right-open-write-access.html)

John Pritchard

Is this right (open for write access)
 
Hi there!
Are these few lines of code correct ?

Workbooks.Open Filename:=FullPath, Notify:=False

' If cranafile opened as read-only then keep trying to
get read/write access

While Workbooks(Cranafile).ReadOnly = True

Application.StatusBar = "Waiting to get read/write
access to " & Cranafile & " ..."
On Error Resume Next
Workbooks(Cranafile).ChangeFileAccess
Mode:=xlReadWrite, Notify:=False

Wend

I'm attempting to ensure the process has read/write
access to <cranafile. This will be run in a multi user
environment where the code is run by several users at
once. I only have a single user system (Windows XP).

Thanks in advance for any useful comments OR confirmation
that it'll be OK.


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com