Command Button Function - Macro

  • Thread starter Thread starter NickH
  • Start date Start date
N

NickH

Hi All

Relatively new to Excel 2000.
I wish to use a command button on a work sheet, to start
a third party application, I am assuming this requires
writing a macro!
Once the third party application is running I will be
able to use the various "DDE" commands to talk between
Excel and the application.

Regards


NickH
 
Have a look at VB Editor help under SHELL which gives a good example ho
to manipulate external apps
 
Hi Brian

Thank you for the help, have done so and it works.

All I need to do now is to find out why something I can do in Access I
cannot do in Excel and that is to create a Macro or VB code through a
Command or toggle button to allow me to send a value(Word or Bit) to a
third party piece of software using DDE at a click of a Switch!
Works fine in Access.

Thanks

Nick
 
Don't really know what you mean. Probably because I haven't dealt wit
those posh new appplications that can use DDE. I have used DDE a bit t
use text files, but don't see how you can navigate screens in anothe
app. Presumably you get to base data somehow, which requires suitabl
access.

I use SendKeys to, for example, tab to the proper box and paste th
data using Ctrl+V.

Perhaps you can post a snippet of your Access to something else code
If it is VBA it should be practically the same in Excel
 
Back
Top