Run-Time Error '1004'  Unable to set the PaperSize Property of the PageSetup Class

Posted on 2005-05-10
Last Modified: 2013-11-22
I get this error when trying to print a shared Excel file

Run-Time Error '1004':
Unable to set the PaperSize Property of the PageSetup Class

.PaperSize = xlPaperLetter

Not familar with this.
Question by:kditroia
    LVL 31

    Assisted Solution

    You would be better off asking this question in the Microsoft Office section.  The folks in this (the WordPerfect Office) section are more likely to suggest "upgrading" to Quattro Pro to resolve your problem.  ;-)

    However to be serious for one moment, it looks as if the error you have is to do with a macro that is being run by the spreadsheet (or the startup macro which executes every time you go into Excel).  Try editing the macro, finding the line with that line in it, then editing that line.  Have you recently installed a third party product which "drives" Excel?  If so, this might be where your problem lies.

    Author Comment

    This job works/prints fine from another workstation to the same printer.

     Wondering if I should re-install Excel.  Hoping not to.
    LVL 31

    Accepted Solution

    My second para: IF you have added a third party product: then uninstalling Excel, deleting the Office directories, then reinstalling will cure the problem.

    Warning: There is a risk uninstalling Office as it may not then reinstall smoothly.

    Author Comment

    ok I fixed it.  I added a Network printer and created a new tcpip port
    Everything works now.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    It can often be challenging to stay relevant in the rapidly evolving world of technology. This can make recruiting talent difficult for companies of all sizes.
    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
    This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now