View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tommy-B[_2_] Tommy-B[_2_] is offline
external usenet poster
 
Posts: 3
Default Always print to a specific location

Hi All,

Question: I have a document that when printed I need it to be printed in the
exact location i specify ie I:\Users\Shipping I have generated some VBA code
that is linked to a button on the active worksheet so when the user is done
entering data they click the button and it prints to PDF. Due to the fact
that there is a speperate woorkbook that links to the prints I have to have
them in that location. Is there somadditional code I can add to make sure it
goes where I need it to???
Any help would be greatful!!!