Printing and save in command prompt

Does anyone know how to do the following.

While in Excel, I have a VB code to print a spread sheet and to give it a

different header by adding 1 to it (e.g. 1, 2,3 ect). I have change the code

to print to Adobe, but how can I send the job to command prompt and then save

the file to a folder on my system or network folder? I have seen this be

done, but I can find the person to set this up.

Thanks