At this moment, i have a document where you enter several output from other programs, this data is converted into some statistics and graphs per person depending on who you select in a combobox (form control). this works fine at this moment.
the excel is connected to a MS Word document which displays the graphs and statistics from the person selected in the excel document.
i would like to have a button that automatically saves the individual document as PDF with a different name.
manual: open both documents
manual: click on the macro
macro: go to first of the combobox list (this can be done by changing output of combobox to 1)
loop
macro: open word and safe as pdf
macro: if number of people that have to be done is same as output combobox, end
macro: go to the next of the list (change output combobox by +1)
end loop
i have tried it for a long time but cannot manage it.
Bookmarks