Does using a macro to look and con mob's and to look at stuff in a room...decrease explore and observe exp?

Not automatically. However, I'm led to believe botting it may motivate a staff to manually yank your ability to gain observation xp.

I have a marco set, so when I push it it will examine chest,table,desk,bed etc..to see if one or more are in the room

Once I already know what to look for I can make a few aliases and run through a high yield observation area in a few minutes. After about the 5th time doing it manually it gets old reexploring every object and mob in Thera.