topic Re: Looking to translate X,Y coordinate system to A-H,1-10 grid. in VBA Forum

Looking to translate X,Y coordinate system to A-H,1-10 grid.

Anonymous — Sat, 17 Apr 2021 21:21:19 GMT

Dealing only with 2D here (X,Y). I have dwgs that contain a grid location system of A through H on the left vertical axis and 1 through 10 on the top horizontal axis. So, for an E size dwg of 48"x36", I would like to list the location of all the objects on the sheet (ie Obj 1 = B4, Obj 2 = G7, Obj 3= D9, etc).

Any suggestions are sincerely appreciated.

Re: Looking to translate X,Y coordinate system to A-H,1-10 grid.

grobnik — Sun, 18 Apr 2021 11:09:27 GMT

Hi @Anonymous ,

I guess you have to check the objects insertion point and on the other side making a cross "table" which convert the object coordinate in "row, column" style.

For example if the object insertion point will be in a range of coords which will be the portion of sheet length or sheet width you can apply the number of correspondent row/column.

I guess it's a large code to do, as alternative you can create a function.

But I'm seeing some issue into this procedure: if the object falls between two rows or two column how to assign to object the right row or column ? do you have a "with-in" range ?.

Re: Looking to translate X,Y coordinate system to A-H,1-10 grid.

Anonymous — Sun, 18 Apr 2021 13:38:04 GMT

It IS possible to have an object located on one or more division lines. Since this project does not require precision, I suppose the lesser of the grid locales is okay to use. For example, if an object is located on the cross-hairs of B3, B4, C3, and C4, it is acceptable to mark the object as located in B3.

Anyone ever seen functions similar to this? If so, got a snippet or link?