Results 1 to 15 of 15

PDF-printer problem

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2011
    Location
    Kaavi
    MS-Off Ver
    Excel 2007
    Posts
    45

    PDF-printer problem

    Hello, I have a problem like this;

    I've recorded macro that selects PDF-printer, converts wanted range into PDF, then opens email application and user can send range to wanted address. Problem is that every time I record macro, it works fine, just like i want it to work.. but when I close workbook, then open it again and run macro, it does not do anything I recorded :P It does select pdf-printer (sometimes) but it wants me to save file (didn't record anything like that), and sometimes it just prints range into paper :P

    Is this macro ruined somehow or doesn't it just work ??

    Point is that user selects "Send PDF", macro then selects PDF-printer, then opens email application where user can write address. All this is working but when I close workbook and then open it, won't work :P

    Here's the code

    Sub SendPDF()
    '
    ' SendPDF Makro
    '
    '
        ActiveWindow.SmallScroll Down:=15
        Range("RANGE").Select
        ActiveWindow.SmallScroll Down:=-69
        Selection.PrintOut Copies:=1
        ActiveWindow.SmallScroll Down:=-3
        Range("A26").Select
        ActiveWindow.SmallScroll Down:=-42
        Range("A26").Select
    End Sub
    Last edited by Crüe; 08-17-2011 at 06:50 AM.

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