Macro to save file by employee and save as PDF in path

Hi all

I am wondering if its possible to have a macro go down a list of employee names and save the file (multiple tabs) in a PDF format on a path on my c:drive?

Here is my request
1) "Employee" tab contains list of employees A2:A6 (my original file contains A2:A108)
-> I would like the macro to go down on by one and change the value in cell E7 on the "Summary" tab (this will update the data points on the Summary, WIP Table, AR Table)
2) Take the tabs "Summary", "WIP Table" and "AR Table" and save as "PDF" format in a single file
3) Save the files by Employee name + Current month on a path on my c:drive

All my data/formulas have been updated, so I simply need a macro that can accomplish the above? There are 107 employees in total, so there should be 107 employee PDF version files.

I have attached a sample, with just 4 employee names....can someone pls help? FYI: I would like the macro to be smart enough to execute based on the # of names listed in the "employee" tab

Thank you so much in advance!

You may need to play with margins or print settings a little... the first page was spilling over into page 2, but this should get you going:

Please Login or Register  to view this content.

Ooops! did a quick test with just 2 names, and didn't change it back : For i = 2 To 3 should be For i = 2 To lr

didn't even notice the month issue... apologies, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Edit: you may want to change the openafterpublish attribute to false once you are doing a bunch of files... I wasn't sure if you want them to open or not.

That is odd.... I dont see why.... Can you post an exact copy of the line you are using in your code for the ExportAsFixedFormat?

The reason is that the path needs to end in a "\" before the filename, there are 2 options, choose ONE of the changes below (change in red):

Please Login or Register  to view this content.

OR:

Please Login or Register  to view this content.