Macro to Open Crystal Reports

5 pts.
Tags:
Crystal Reports
Excel macros
Microsoft Excel
I have an excel spreadsheet that I've used to create a crystal report. The excel file has multiple employee id's on it. The crystal report has a parameter that uses the employee id to only show that employee's information. I'm trying to set up a macro to loop through the employee ID column, pass one employee ID to the crystal report, export the crystal report as a PDF and save it with the employee ID in the file name. is it possible to use a macro for this purpose? In my test file, I only have 3 employee ID's but will have over 7000 if I'm able to figure it out. I've search this board and many others to try and find some code to help me out but am at a loss. Thanks in advance to all who might be able to shed some light on this.
ASKED: May 4, 2009  2:27 PM
UPDATED: May 4, 2009  2:41 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following