Macro Recorder

[Jaye7]

Just wondering if you can use excel like a macro recorder program IN THE FOLLOWING WAY.

With a macro recorder program the program clicks on specific points of i.e. latitude longitude, so if you had a textbox or userform etc... you could have a script to select a specific point anywhere on your page.

If so can someone please advise how to achieve it as at the moment my macro will only click on a cell address/ location not a specific point.

Thanks

 

[Blade Hunter]

Not sure if this is what you want but it will return the mouse position.

Dim MyPointAPI As POINTAPI
Private Type POINTAPI
  X As Long
  Y As Long
End Type
Private Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long
Public Sub Timer1_Timer()
  l = GetCursorPos(MyPointAPI)
  MsgBox CStr(MyPointAPI.X) & ", " & CStr(MyPointAPI.Y)
End Sub

Cheers

Dan

 

[Jaye7]

Thanks for your reply blade hunter, sorry for the late response, been busy.

Just what I am after, I have added a wait function so that I have time to go to the point I am after.

Can you please provide a with script that utilizes the points as I'm not the best with script writing i.e. something like

with CStr(MyPointAPI.X) & ", " & CStr(MyPointAPI.Y).address
leftmouseclick
end with

Thanks.