MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Shell and Process ID

  Asked By: Kavisha    Date: Mar 25    Category: MS Office    Views: 2493

In EXcel VBA, we can invoke 3 Notepad application windows by:

x = shell("notepad.exe",1)
y = shell("notepad.exe",1)
z = shell("notepad.exe",1)

and obtain PIDs in x, y and z, respectively.

How do we differentiate these differnt windows later when we
need to do things like:

Application.wait Now + TimeValue("00:00:10")
SendKeys "%EP", True

Can I do something like:

Application.x.wait Now + TimeValue("00:00:10")
x.SendKeys "%FO", True

Application.y.wait Now + TimeValue("00:00:10")
y.SendKeys "%EP", True

Application.z.wait Now + TimeValue("00:00:10")
z.SendKeys "%EP", True



No Answers Found. Be the First, To Post Answer.

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