I have been trying to run another app from an Access for button, but it's not working as I would like it.
I can get the app to open using Shell, but I can't seem to control it in any way. I've tried AppActivate and SendKeys, but it doesn't seem to work. All of my keystrokes stay in Access instead of going to the other app.
Is it possible to perhaps run a batch file or some other script that will run the outside program and do the things I need done outside of Access. If so, does anyone have any scripting programs or macro programs they can recommend that would do the trick?
Or does anyone have any tips for controlling other apps from Access using VBA?
Thanks,
--sam
I can get the app to open using Shell, but I can't seem to control it in any way. I've tried AppActivate and SendKeys, but it doesn't seem to work. All of my keystrokes stay in Access instead of going to the other app.
Is it possible to perhaps run a batch file or some other script that will run the outside program and do the things I need done outside of Access. If so, does anyone have any scripting programs or macro programs they can recommend that would do the trick?
Or does anyone have any tips for controlling other apps from Access using VBA?
Thanks,
--sam