saint_2008
Board Regular
- Joined
- Sep 6, 2007
- Messages
- 103
Morning all,
I'm trying to open excel's version history in SharePoint using the app version of excel,
So Far, I have it opening SharePoint URL.
But the send-keys command goes to Chrome and not the SharePoint excel sheet. I've even played a mouse click in the code to see if that would focus it on SharePoint before doing the send-keys command,
I'm trying to open excel's version history in SharePoint using the app version of excel,
So Far, I have it opening SharePoint URL.
But the send-keys command goes to Chrome and not the SharePoint excel sheet. I've even played a mouse click in the code to see if that would focus it on SharePoint before doing the send-keys command,
VBA Code:
Public Sub OpenUrl()
Dim lSuccess As Long
lSuccess = ShellExecute(0, "Open", "https:sharepoint.com/excel" 'Link Removed
Application.Wait (Now + TimeValue("00:00:05"))
'mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0
'mouse_event MOUSEEVENTF_LEFTUP, 0, 0, 0, 0
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment Text:=""
End If
SendKeys "%fip"
End Sub