Results 1 to 3 of 3

Thread: Printout from excel without common dialog

  1. Feb 17th, 2004, 08:43 AM #1
    lennart
    lennart is offline

    Thread Starter
    Lively Member
    Join Date
    May 2000
    Posts
    74

    Printout from excel without common dialog

    I want to produce a macro in excel where I do a print (to file) and hardcode the filename - and not get any common dialog window.
    SOmeone who knows how to do that??
    Reply With Quote Reply With Quote
  2. Feb 19th, 2004, 02:56 AM #2
    lennart
    lennart is offline

    Thread Starter
    Lively Member
    Join Date
    May 2000
    Posts
    74
    Is there noone who can tell how to supress the common dialog windows when printing from macro in excel?
    Reply With Quote Reply With Quote
  3. Feb 19th, 2004, 10:31 PM #3
    TheFIDDLER
    TheFIDDLER is offline
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126
    Depends on which version of Excel you are using.

    This is from the Excel Help File.

    In Excel 97
    PrintToFile Optional Variant. True to print to a file. Microsoft Excel prompts the user to enter the name of the output file. There's no way to specify the name of the output file from Visual Basic.


    In Excel XP
    expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)

    PrToFileName Optional Variant. If PrintToFile is set to True, this argument specifies the name of the file you want to print to.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width