alternative to SendKeys in VBA editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobby - 02 Nov 2004 19:16 GMT

Hello,

I'm trying to do some simple emacs-like macros in the VBA editor for
access. I've figured out how to use VBA.SendKeys to insert the text I
want, but I'm wondering if anyone can tell me a better way to do it.
specifically I'd like to have direct access to the document currently
being edited, but I can't seem to find it.

This is in access 2002

Thanks.

Reply to this Message

Stephen Bullen - 02 Nov 2004 22:14 GMT

Hi Bobby,

> I'm trying to do some simple emacs-like macros in the VBA editor for
> access. I've figured out how to use VBA.SendKeys to insert the text I
[quoted text clipped - 3 lines]
>
> This is in access 2002

The objects to manipulate the VBA Editor are all in the 'Microsoft
Visual Basic for Applications Extensibility' library. I don't know of
any online resources that explain how to manipulate it in detail, but I
wrote about it (from an Excel POV, but most is the same for Access) in
the Excel 2002 VBA Programmers Reference.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Reply to this Message