Hi,

I have inherited an excel-report which I would like to automate. Every day I
need to
save in pdf-format around 12 reports from 12 different selections in a
drop-down list (I am not sure it is a drop-down list but it looks like that).

Is it possible to automatically do the following: 1) Da a selection for each
possible selection in the drop-down list 2) Save it as a pdf-report and give
it the same name as the selection in the drop-down list. Save each report on
the desktop.

Automatic calculation is shut off in the workbook. I assume I need to tell
excel to turn it on during this procedure.


Many thanks in advance!

Sverre