View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default Linking to other VB apps


"Sullivan" wrote in message
...
Hey all

I'm working on a project that will require me to link to
an application that was created in standard VB 6.0 (NOT
VBA) while in VBA. Is this possible? And if it is, can
you let me know how it's done????

Thanks in advance

Sullivan


If the application is an activex dll then you can treat it
as any other automation server including Excel itself.

If however the application is an exe it gets more complicated.

You can start it with the shell command and use sendkeys
to send command strings to any input window it may have
but at best it will be a lash up

Keith