Results 1 to 20 of 34

Thread: Excel VBA invokes Word

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-27-2007, 12:57 AM #28
    Charlize
    Charlize is offline
    VBAX Master
    Joined
    Jul 2006
    Location
    Belgium
    Posts
    1,285
    Location
    Put this after your printcommand 

    Application.Wait (Now + TimeValue("0:00:10"))
    Because your printer needs time to process the request. If you close the document immediately, the printspooler can't fetch the request.

    Suggestion to put coding in a normal module. Right click with mouse on project window (left side of screen) and choose insert module.

    2nd suggestion. Use doubleclick on a line to print the line.

    Charlize
    Last edited by Aussiebear; 04-02-2025 at 04:54 AM.
    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