Calling Crystal from VBA

[jjd100]

I would like to invoke a Crystal report from VBA and pass a few parameters to Crystal as well. Does anyone know how to do this?

 

[kjv1611]

It might not be the cleanest way to do so, but I know for sure that you can use the Shell Command, and then for passing parameters, could use use the SendKeys command?

 

[jjd100]

invoking from the shell works, the send key isn't working. Any other ideas? lots of documentation using vb.net or vb6, how about vba? :-(

 

[PHV]

Which VB6 code you can't migrate to VBA ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kjv1611]

How are you using SendKeys? Can you paste your code here, maybe there's a typo or syntax error...

For instance, If I wanted to send keystrokes to Notepad, and already have a document open which says "Untitled - Notepad" in the menu bar, I could do this:

AppActivate "Untitled - Notepad"
SendKeys "Hello, world!"
SendKeys "{ENTER}"
SendKeys "{ENTER}"
SendKeys "That was two carriage returns!"

Of course, you can also tell how many times to send a particular string or character, as well.

Also, if it seems to buggy in your particular application, you can try using the MySendKeys API call function which Dev Ashish posted on his Microsoft MVP website. Just do a google search for MySendKeys, and it should be the 1st or 2nd link.