View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Prinout function

Hello,

Trying to get a grasp of the VB stuff behind a spreadsheet. I am trying to
print the current spreadsheet so am trying to use the printout function.

I think I am using the [PrToFileName] property incorrectly but I do not know
what it expects. An example of what I have tried is:
me.PrintOut (,,,,,TRUE,,"U:\weeklyreport")

How do you define the file name to print the current spreadsheet to?