Set shell as object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,
I am attempting to set a shell as an object and can't seem to figure it out.
Any help would be greatly appreciated. Here is what I have so far.

Dim System As Object
Set System = CreateObject(Shell("C:\WINDOWS\system32\Notepad.exe", 3))
 
I don't believe it's possible to do that.

What are you hoping to accomplish? It's probable that someone can offer an
approach to achieve that.
 
I need a way to switch back and fourth between access and the shell. So If I
have an input box to the user then I need for a way to refocus on the shell
that the user was working from. I am not actually using notepad for my final
product it is nothing more then an illustration. I am using a very archaic
program in conjunction with access and need to run some functions from access
into the program.

Thank-you for your help anyways.
 
I'm not sure that you can reliably transfer values into a program running
through the Shell command.
 
Back
Top