Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Word Locked

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trini - 10 Nov 2007 21:43 GMT
I have a trial version that I just downloaded about two weeks ago.  It caused
my previous version to no longer work and my disc to reinstall is corrupted.  
It is now locked and will not let me do anything.  It did not lock until I
finally put the code in and now I can no longer type.   I am a student and a
professional educator so I am highly frustrated with this problem.  Can
someone please help me quickly?
Chris - 11 Nov 2007 00:41 GMT
Hi

I have a a macro running in Word 2003 to print a label on a networked label printer, by
switching to the label printer, print the label (with some formatting) and then switch
back to the default printer (also networked). All works well except the macro takes 25
seconds to complete. By stepping through the macro I find that the commands that take all
the time are

Application.ActivePrinter = LabelPrinter (switch to label printer)
ActiveDocument.PrintOut Copies:=nNumberCopies, Range:=sPrintRange, Background:=False
Application.ActivePrinter = strActivePrinter (switch to default)

I have found that same problem on another computer where the printers are directly
connected and not on a network. Here only the  Application.ActivePrinter statements were
slow.

The PC is a Dual core with 2 GB RAM and a large hard disk.

Has anyone any ideas on how to speed up this macro?

Thanks

Chris

Adelaide

Australia
Doug Robbins - Word MVP - 11 Nov 2007 01:12 GMT
Make sure that you have the printer drivers installed on the local machine
and are not using a driver that is installed on the network somewhere.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi
>
[quoted text clipped - 25 lines]
>
> Australia
Chris - 11 Nov 2007 01:29 GMT
For the standalone PC drivers are on the PC.

> Make sure that you have the printer drivers installed on the local machine
> and are not using a driver that is installed on the network somewhere.
Chris - 12 Nov 2007 08:47 GMT
For the standalone PC drivers are on the PC.  Does anyone else have any ideas why the
macro goes slowly at statementApplication.ActivePrinter =

Chris

Make sure that you have the printer drivers installed on the local machine
and are not using a driver that is installed on the network somewhere.

-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis. Doug Robbins - Word MVP "Chris"
<har1@internode.on.net> wrote in message news:13jcjtd9iq2457d@corp.supernews.com...
> > Hi
> >
[quoted text clipped - 25 lines]
> >
> > Australia
Russ - 13 Nov 2007 05:55 GMT
Chris,
Like Doug said, make sure you install all the printer drivers that you are
using, on the (local) machine that is running the code, otherwise there will
be a delay when running that code.

> For the standalone PC drivers are on the PC.  Does anyone else have any ideas
> why the
[quoted text clipped - 39 lines]
>>>
>>> Australia

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Chris - 13 Nov 2007 10:47 GMT
Thanks for this suggestion but even when the printer drivers the macro is still slow - 15
seconds to do a little formatting swap printers print and swap printers back.

Chris

> Chris,
> Like Doug said, make sure you install all the printer drivers that you are
[quoted text clipped - 44 lines]
>>>>
>>>> Australia
Doug Robbins - Word MVP - 11 Nov 2007 01:10 GMT
See the KnowledgeBase article "How to Replace Lost, Broken, or Missing
Microsoft Software or Hardware" at:

http://support.microsoft.com/default.aspx?scid=kb;[ln];326246

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a trial version that I just downloaded about two weeks ago.  It
>caused
[quoted text clipped - 5 lines]
> professional educator so I am highly frustrated with this problem.  Can
> someone please help me quickly?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.