VBA - Working with Excel 2007 and SharePoint, checking file status

I have an issue, I'm working with a file from SharePoint (FileA), "FileA" goes out to Sharepoint and opens "FileB" (if not already open) then copies information from "FileA" to "FileB". However if "FileA" is left open, or someone else has it open I am unable to open "FileA". How in VBA can I check to ensure I don't have it open locally (if so swich and continue), checkout and open in SharePoint (if not already open) or Prompt with options to force checkin, checkout to copy info?

Fairly new to VBA in Excel, so may need you to dumb down a little.

Simple VBA copy I used:

Workbooks.Open FileName:= _
"http://sharepoint.baaa.com/sites/SCDT_DSD/Weekly_Releases/11.%20Combined%20Weekly%20Task%20List/1/Automated_Status_Update.xlsm"
Sheets("1").Select
Range("A1").PasteSpecial Paste:=xlPasteValues


Thanks in advance for any help you can provide

From what I read here Nathansav, this procedure would try to open the SP file, but if not able it would specify the error msgbox in this case. But what if the file were already open locally. For example I have open the Automated_Status_Update file already on my computer, from another workbook I open a macro with the above VBA code. I get the error because SP shows the Automated_Status...file is already being used in Edit mode... instead I want to switch to the already open file on my computer and continue the code. Does that make sense? As a secondary questoin: If it's already checked out or being edited by someone else, can I force the file to checkin through VBA code and then run my VBA?

By the way, my first time in these forums, they seem very useful... I really appreciate your help.