+ Reply to Thread
Results 1 to 3 of 3

Macro Stopped Working - Run-Time error '1004':

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2016, O365
    Posts
    97

    Macro Stopped Working - Run-Time error '1004':

    Hi All,

    I have been using this macro for months to print to default printer and then print to Cute PDF and it has been working great. All of a sudden its not working and I am getting the following error in Excel 2013:

    Run-Time error '1004':
    Methos 'ActivePrinter' of object '_Application Failed



    Please Login or Register  to view this content.
    I have double checked that the ports are the same and correct as the code. Any idea whats happening? I'm lost!

    Les

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Macro Stopped Working - Run-Time error '1004':

    9 out 10, it's port change.

    Try something like...
    Please Login or Register  to view this content.
    Code will loop through and try to find the USB port printer is connected to. If not able to set, it will at least tell you what current ActivePrinter is.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    01-27-2012
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2016, O365
    Posts
    97

    Re: Macro Stopped Working - Run-Time error '1004':

    Thanks for the reply! When I try to run this I get:

    Cannot Run the macro. The Macro may not be available in this workbook or all macros may be disabled.

    In Trust centre I have selected trust all macros and have selected trust VBA as well.

    Any thoughts?

    Les

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 'Run Time Error 1004' in prevciously working macro
    By terrypin in forum Excel General
    Replies: 5
    Last Post: 07-13-2018, 08:18 AM
  2. Replies: 5
    Last Post: 05-14-2016, 01:24 AM
  3. macro stopped working. runtime error
    By sameclipse in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-14-2015, 01:02 PM
  4. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  5. Pivot table source not working run time error 1004
    By vba317 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2014, 04:03 PM
  6. Pivot table source not working run time error 1004
    By vba317 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-22-2014, 05:15 PM
  7. run-time error '1004' - advanced filtering not working
    By scubadiver007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 05:49 PM

Tags for this Thread

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