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.