+ Reply to Thread
Results 1 to 2 of 2

Make it wait

  1. #1
    Registered User
    Join Date
    06-26-2008
    Location
    New Zealand
    Posts
    41

    Make it wait

    I have two macros.

    The first one Prints to pdf and the second emails with the pdf attached.

    But, I can't get the second one to wait until the printing is finished before starts. I have tried putting an Application.Wait between them but that freezes the printing macro.

    Is there a way to test the printing or at least wait a while to give the printing time to finish?

    Here is my real simple printing macro:

    swbAName = ActiveWorkbook.Name
    Workbooks(swbAName).Worksheets("Results").Select
    MsgBox "Save name must be Box League Results"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
    "CutePDF Writer on CPW2:", Collate:=True

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Make it wait

    Please read the forum rules and then amend you're title and wrap you're code

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1