MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Mehndi    Date: Feb 18    Category: MS Office    Views: 2171

Could anyone of you help me how can we use Sendkeys command in VBA?
1) Can we use sendkeys to operate SAP from VBA?
2) Is that anyway Sendkeys help us to minimize the manual operations ?
Please help me



2 Answers Found

Answer #1    Answered By: Cadencia Bernard     Answered On: Feb 18

The answer is Yes. You can do it provided you can control SAP using only
the keyboard.

However It does depend on knowing the exact key sequence you will be using
when you write the code. It breaks easily if, for example, SAP changes the
menu structure.

I would prefer to use OLE if that is available.

If the interaction is not trivial I would probably be looking at an external
tool like VB or a scripting language to control both Excel and SAP with
internal macros in both to produce the info required.

To find out more about Sendkeys type the word Sendkeys into the help  box in
the VBE.

Answer #2    Answered By: Patty Freeman     Answered On: Feb 18

Thanks for your information.
Could you please help  me, how can we access SAP through OLE in Excel VBA.
Can we make OLE coding in Excel? If not, do we need to use only VB 6 for OLE ?
Please guide me!

Didn't find what you were looking for? Find more on sendkeys Or get search suggestion and latest updates.