Connecting Tech Pros Worldwide Help | Site Map

alternative to SendKeys in VBA editor

  #1  
Old November 13th, 2005, 05:04 AM
Bobby
Guest
 
Posts: n/a
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.
  #2  
Old November 13th, 2005, 05:04 AM
Stephen Bullen
Guest
 
Posts: n/a

re: alternative to SendKeys in VBA editor


Hi Bobby,
[color=blue]
> 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[/color]

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


Closed Thread