How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In

I am trying to get the following code to work when I transfer the file from the server into SharePoint. The main workbook checks to see if the second workbook is read only before processing the rest of the code. If it is read only it tells the user they cannot continue and closes the second workbook. I am having trouble getting it to do the same in SharePoint.

Code works on server

Please Login or Register  to view this content.

I found info that Read Only does not work In SharePoint so I have tried variations of trying to check if it can be checked out and checking it out but it wont check out.

Please Login or Register  to view this content.

The code runs through without errors but hangs up and says that excel is waiting for another application to complete on OLE action causing me to use Task Manager and stop the process. When I open the second file, I see that it was never checked out so I am assuming it hangs up there. I can modify the files to make them small enough to attach if someone needs to see them to help out.

Ok, I have gotten the following code to work, but I had to unprotect the workbook to do it. Anyone know how I can keep the workbook protected and enter the password with the code. Its weird though because even when using application.screenupdating, the screen still flashes with the other document briefly.

Please Login or Register  to view this content.

When I use the following code, it works but I am prompted for the password to check out the file.

Please Login or Register  to view this content.

it wont allow me to enter a password in the code when checking out the file
Workbooks.CheckOut (strFile), Password:="dstmfg" ---wont work
Workbooks.CheckOut (strFile, Password:="dstmfg") ---wont work

Any ideas??