Crossing walls- Sci fi

Few days back I saw a series named ‘Fringe’ in which there was a scene where the criminals who were basically into robbery crossed a wall via manipulating the atoms of the wall.

Apparently they installed a machine which changed the frequency of oscillation of the atoms of the wall and made the robbers pass as the structure of the wall changed to semi solid and after sometime it was back to normal.

We know the concept of sublimation, where a substance transform directly to the gaseous state from solid and missing the liquid part. But is it possible to make the object have its status back to normal?

Our mind is a connection of neurons with infinite possibilities!! I am sure there might be some crazy scientist who would be doing such experiments.

Is it possible for humans to get so much advanced that we could have the ability to transform any material to any state and pass through??

Can this be used as spying technology in future years after 500-600years??

This will be a great things to save time as we will not require to open refrigerator door which might save 2-4 seconds of our life.

Is there a possibility that this type of technology has already been developed and used by the intilligence agencies?

Will James Bond will be able to cross through opaque solid objects at one go??? Is it possible that the things we call ghosts are the people passing from one dimension to another??

Will it be possible to change our DNA so that instead of changing the molecular structure of the object we could have so much power to do it ourselves??