Visual Basic Error when Printing multiple documents

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
dell optiplex 990 running windows 7 64 bit fully patched and office 2007 fully patched. When printing multiple documents through windows explorer I get the error.

run-time error 509

the fileopen command is not available because your permission for this document is currently restricted.
Question by:MapleLife
  • 3
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37019317
Hello MapleLife, where are the documents located that you are trying to print? Local / share / sharepoint / other?

Author Comment

ID: 37019477
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 37020095
Do any of the documents you are trying to print contain macro's that run when a document is opened? The macro running may cause the error when the Explorer is opening next document(s). Here's some details about when trying to print more than 15 documents using Explorer in Windows 7. There seems to be a limit of 15 files which wasn't there in WindowsXP.
LVL 38

Accepted Solution

Gerwin Jansen, EE MVE earned 2000 total points
ID: 37020112
Here's a solution that may be of help, I didn't test this myself but I'd be looking for a batch tool like Print Conductor.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
New style of hardware planning for Microsoft Exchange server.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

850 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