R
ryguy7272
I’m following the example here:
http://msdn.microsoft.com/en-us/library/aa223808(office.11).aspx
Here’s my code:
' Determine if workbook can be checked in.
If Workbooks(SaveFile).CanCheckIn = True Then
Workbooks(SaveFile).CheckIn
MsgBox SaveFile & " has been checked in."
Else
MsgBox "This file cannot be checked in " & _
"at this time. Please try again later."
End If
‘SaveFile’ is dimmed as a string; it is the name of my Excel file,
which comes from here:
SaveFile = Left(imgElement.Title, 27)
I mouse-over the variable and see that the value is correct, but the
code fails on this line:
If Workbooks(SaveFile).CanCheckIn = True Then
SaveFile is checked out from SharePoint. How come I can’t check it
in? Do I need to fully qualify SaveFile with the path to SharePoint
so Excel knows WHERE to check the file in?
I’d appreciate any ideas with this.
Thanks!!
Ryan---
http://msdn.microsoft.com/en-us/library/aa223808(office.11).aspx
Here’s my code:
' Determine if workbook can be checked in.
If Workbooks(SaveFile).CanCheckIn = True Then
Workbooks(SaveFile).CheckIn
MsgBox SaveFile & " has been checked in."
Else
MsgBox "This file cannot be checked in " & _
"at this time. Please try again later."
End If
‘SaveFile’ is dimmed as a string; it is the name of my Excel file,
which comes from here:
SaveFile = Left(imgElement.Title, 27)
I mouse-over the variable and see that the value is correct, but the
code fails on this line:
If Workbooks(SaveFile).CanCheckIn = True Then
SaveFile is checked out from SharePoint. How come I can’t check it
in? Do I need to fully qualify SaveFile with the path to SharePoint
so Excel knows WHERE to check the file in?
I’d appreciate any ideas with this.
Thanks!!
Ryan---