X Y Coordinate Issue | Screen Size Difference | Reconfigure the Structure of Coding

Please_H

Board Regular
Joined
Apr 16, 2017
Messages
181
Office Version
  1. 2019
Platform
  1. Windows
Hello Everyone,

I hope everyone of you are safe and sound from COVID-19.

I ran into an issue today regards to X and Y coordinates regards to screen ( Monitor ) size.
I am using a 15'6 Inch screen and my friend is using a 13 inch screen.

I recorded Macro's with screen coordinates for her project and now when I try to run them on her PC, due to the screen size all clicks are a huge bundle of mess.

Each coding comes from MiniMouseMacro app and each colomn in excel when copy pasted look like below,

Unfortunately these coding gets posted into One Column and not cell by cell,

They refer to,

Seq. No | X Axis | Y Axis | Mili seconds spent on the action | Action | Action Key ( like last scenario of "tab" )


1 | 836 | 50 | 300 | Keypress pgup

2 | 836 | 50 | 300 | Left Click Down

3 | 836 | 50 | 300 | Left Click Release

119 | 1358 | 148 | 100 | Left Click Release

120 | 1358 | 20 | 30000 | Keypress Ctrl+ | tab

How can I get these changed to 13 Inch or any other Screen Inch type, and also not lose the structure of the recording?

When I point my Mouse pointer to the top left corner the coordinates stands at,

0 | 0

When I point my Mouse pointer to the top left corner the coordinates stands at,

1365 | 767

if that info helps in any case and hoping that if I can take my friends coordinates as such and do something as well.

Please help as these are heaps and heaps of records.

Many Thanks.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Please_H

Board Regular
Joined
Apr 16, 2017
Messages
181
Office Version
  1. 2019
Platform
  1. Windows
Trying to do some math I realized,

No matter the Screen Sizes change the Ratios are consistent.

For an Example,

If my Laptop is,

X0 as Old - 1376
Y0 as Old - 768

X1 as New - 1920
Y1 as New - 1080

if my Laptop Mouse Pointer is at, 836 | 50,

New Coordinates would be,

1920/1376 x 836 - 1166 ( X1 ) Percentage = 139%
1080/768 x 50 - 70 ( Y1 ) = 140%

Just suggesting
:)
 

LuBuExc

New Member
Joined
Aug 8, 2019
Messages
2
Hello Everyone,

I hope everyone of you are safe and sound from COVID-19.

I ran into an issue today regards to X and Y coordinates regards to screen ( Monitor ) size.
I am using a 15'6 Inch screen and my friend is using a 13 inch screen.

I recorded Macro's with screen coordinates for her project and now when I try to run them on her PC, due to the screen size all clicks are a huge bundle of mess.

Each coding comes from MiniMouseMacro app and each colomn in excel when copy pasted look like below,

Unfortunately these coding gets posted into One Column and not cell by cell,

They refer to,

Seq. No | X Axis | Y Axis | Mili seconds spent on the action | Action | Action Key ( like last scenario of "tab" )


1 | 836 | 50 | 300 | Keypress pgup

2 | 836 | 50 | 300 | Left Click Down

3 | 836 | 50 | 300 | Left Click Release

119 | 1358 | 148 | 100 | Left Click Release

120 | 1358 | 20 | 30000 | Keypress Ctrl+ | tab

How can I get these changed to 13 Inch or any other Screen Inch type, and also not lose the structure of the recording?

When I point my Mouse pointer to the top left corner the coordinates stands at,

0 | 0

When I point my Mouse pointer to the top left corner the coordinates stands at,

1365 | 767

if that info helps in any case and hoping that if I can take my friends coordinates as such and do something as well.

Please help as these are heaps and heaps of records.

Many Thanks.
Sorry, no answer but a question. How do you get the mouse pointer coordinates?
 

Please_H

Board Regular
Joined
Apr 16, 2017
Messages
181
Office Version
  1. 2019
Platform
  1. Windows
Sorry, no answer but a question. How do you get the mouse pointer coordinates?

This was done by selecting the exact screen location by an automation software.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,418
Members
412,529
Latest member
cTatch
Top