FIND & REPLACE MACRO (Microsoft Access)

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

I am building a macro to find and replace zeros (0) that are imported from
Excel (blank cells). I have used a combination of Select Object, RunCommands
and SendKeys to accomplish this action. It seems to work up to the point of
"REPLACE ALL" I can't find an action that would force "ENTER" to complete
the action. Any thoughts would be appreciated!
 
Shirley,

It is not 100% clear what you are trying to do here. But I would expect
that running an Update Query on your imported data, possibly employing the
Replace() function, would be the way to go here. Once you have set up your
Update Query, you can use an OpenQuery action in your macro to run the
update.
 
Back
Top