Results 1 to 15 of 15

PDF-printer problem

Threaded View

Crüe PDF-printer problem 08-08-2011, 01:01 AM
Mordred Re: PDF-printer problem 08-08-2011, 02:16 AM
gjlindn Re: PDF-printer problem 08-08-2011, 02:22 AM
Crüe Re: PDF-printer problem 08-08-2011, 02:22 AM
gjlindn Re: PDF-printer problem 08-08-2011, 02:32 AM
royUK Re: PDF-printer problem 08-08-2011, 02:44 AM
Crüe Re: PDF-printer problem 08-08-2011, 02:49 AM
gjlindn Re: PDF-printer problem 08-08-2011, 03:01 AM
Crüe Re: PDF-printer problem 08-09-2011, 03:58 AM
royUK Re: PDF-printer problem 08-09-2011, 04:25 AM
Crüe Re: PDF-printer problem 08-09-2011, 04:30 AM
royUK Re: PDF-printer problem 08-09-2011, 04:35 AM
Crüe Re: PDF-printer problem 08-09-2011, 05:12 AM
royUK Re: PDF-printer problem 08-09-2011, 02:21 PM
Crüe Re: PDF-printer problem 08-10-2011, 01:01 AM
  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