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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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
:)
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,214,523
Messages
6,120,030
Members
448,940
Latest member
mdusw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top