save as dialogue box

[stevecontracts]

hi guys

looking to make a macro work for me
by selecting three specific sheets
then selecting cell a2
and calling up the save dialogue box
it will then save as whatever is in cell a2+forms
so eg J5555 forms
and automatically select the pdf format

i will then select the destination folder from there

thanks in advance

[dominicb]

http://www.excelforum.com/excel-gene...logue-box.html