FIND & REPLACE MACRO (Microsoft Access)



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!

Steve Schapel


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question