How to pass a variable from VBA to Crystal Reports?

[dsatino]

I'm sure the first question will, of course, be why. Please just trust me that I need it.

Basically what I need is this:

1. Code to open a Crystal Report
2. Code that passes date parameters to the Crystal Report

[ADezii]

I'm sure the first question will, of course, be why. Please just trust me that I need it.

Basically what I need is this:

1. Code to open a Crystal Report
2. Code that passes date parameters to the Crystal Report

Try using the FollowHyperlink () Method or the Shell Execute() API Function.

[dsatino]

Try using the FollowHyperlink () Method or the Shell Execute() API Function.

Thanks, any idea on how to pass parameters/variables over?

Ah, nevermind I see that these carry options for parameters. Sorry for the non-researched response.

[ADezii]

Thanks, any idea on how to pass parameters/variables over?

Ah, nevermind I see that these carry options for parameters. Sorry for the non-researched response.

FollowHyperlink () has an Extra Info Argument that you may/may not be able to use, while ShellExecute() can accommodate Command Line Parameters which should definitely work. What I am not sure of, is how you would retrieve these on the Crystal Reports side.

[NeoPa]

dsatino: Sorry for the non-researched response.

Don't be so hard on yourself. You're doing just fine. A valued member of the community already :)