How do I print 100+ .doc from a SINGLE request? sorry for wronggroup

R

Robert A. Macy

On one machine, running
Win98 and MS Office 97

on another machine, running
WinXP and MS Office 2003

using either machine, every now and then I need to print a 'folder' of
documents

Is there an easy way to set up for a SINGLE print statement to print
all 100+ of these.

I've historically clicked to open each one, then print each one, but
when there's this many that gets a bit tedious.

Sorry, for the wrong group, but I figure you guys know how to do
this.

Robert
 
G

Gary S. Terhune

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

Select All (Ctrl-A), then right-click, Print. Problem is, say you use this
method to print 100 DOCs, it immediately opens all 100 files, then sends
each one to the printer before closing the file. Your system may find that
to be a bad idea. choke on it all. You might want to do it in smaller
chunks.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Robert A. Macy" <macy@california.com> wrote in message
news:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...
> On one machine, running
> Win98 and MS Office 97
>
> on another machine, running
> WinXP and MS Office 2003
>
> using either machine, every now and then I need to print a 'folder' of
> documents
>
> Is there an easy way to set up for a SINGLE print statement to print
> all 100+ of these.
>
> I've historically clicked to open each one, then print each one, but
> when there's this many that gets a bit tedious.
>
> Sorry, for the wrong group, but I figure you guys know how to do
> this.
>
> Robert
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

Google is your friend.
http://support.microsoft.com/kb/306346
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Robert A. Macy" <macy@california.com> wrote in message
news:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...
> On one machine, running
> Win98 and MS Office 97
>
> on another machine, running
> WinXP and MS Office 2003
>
> using either machine, every now and then I need to print a 'folder' of
> documents
>
> Is there an easy way to set up for a SINGLE print statement to print
> all 100+ of these.
>
> I've historically clicked to open each one, then print each one, but
> when there's this many that gets a bit tedious.
>
> Sorry, for the wrong group, but I figure you guys know how to do
> this.
>
> Robert
 
R

Robert A. Macy

Re: How do I print 100+ .doc from a SINGLE request? sorry for wronggroup

On May 20, 2:35 am, "Jeff Richards" <JRicha...@msn.com.au> wrote:
> Google is your friend.http://support.microsoft.com/kb/306346
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "Robert A. Macy" <m...@california.com> wrote in messagenews:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...
>
>
>
> > On one machine, running
> > Win98 and MS Office 97

>
> > on another machine, running
> > WinXP and MS Office 2003

>
> > using either machine, every now and then I need to print a 'folder' of
> > documents

>
> > Is there an easy way to set up for a SINGLE print statement to print
> > all 100+ of these.

>
> > I've historically clicked to open each one, then print each one, but
> > when there's this many that gets a bit tedious.

>
> > Sorry, for the wrong group, but I figure you guys know how to do
> > this.

>
> > Robert- Hide quoted text -

>
> - Show quoted text -


Gary,

You're right about the system choking on 100+

Jeff, those 'sequential' print macros look like EXACTLY what I need,
thank you.

Uh,... I can easily use a text editor to create such a macro, but what
ending three letters should the file name have?

And, how do I initiate the macro?

Robert
 
R

Robert A. Macy

Re: How do I print 100+ .doc from a SINGLE request? sorry for wronggroup

On May 21, 10:40 am, "Robert A. Macy" <m...@california.com> wrote:
> On May 20, 2:35 am, "Jeff Richards" <JRicha...@msn.com.au> wrote:
>
>
>
>
>
> > Google is your friend.http://support.microsoft.com/kb/306346
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Robert A. Macy" <m...@california.com> wrote in messagenews:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...

>
> > > On one machine, running
> > > Win98 and MS Office 97

>
> > > on another machine, running
> > > WinXP and MS Office 2003

>
> > > using either machine, every now and then I need to print a 'folder' of
> > > documents

>
> > > Is there an easy way to set up for a SINGLE print statement to print
> > > all 100+ of these.

>
> > > I've historically clicked to open each one, then print each one, but
> > > when there's this many that gets a bit tedious.

>
> > > Sorry, for the wrong group, but I figure you guys know how to do
> > > this.

>
> > > Robert- Hide quoted text -

>
> > - Show quoted text -

>
> Gary,
>
> You're right about the system choking on 100+
>
> Jeff, those 'sequential' print macros look like EXACTLY what I need,
> thank you.
>
> Uh,... I can easily use a text editor to create such a macro, but what
> ending three letters should the file name have?
>
> And, how do I initiate the macro?
>
> Robert- Hide quoted text -
>
> - Show quoted text -


Sorry to reply to myself, but...

I found that *if* I open Word pull down Tools and then create a macro,
I get to creat a macro.

I called it PrintAll and placed all the text from Jeff's URL for Word
2003 print from a folder.

I created a file under My Documents called $Writing and placed
four .doc in there

After creating the macro and adding the directory name to the
appropriate place, I then saved the macro, closed the macro.

Then I opened Word again, called up the PrintAll macro and asked to
run it. ...NOTHING

Uh, what's going on here?

Robert
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

This is really a WORD question and you will get better answers in a WORD
group. The first thing I would try is to run the macro in diagnostic mode,
so you can see what happens as it executes each line. It's probably
exiting the macro at an error of some sort. Did you use the macro for your
particular version of WORD - they are all slightly different?
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Robert A. Macy" <macy@california.com> wrote in message
news:1c28dea3-0119-4726-84f4-e775fca0456d@w34g2000prm.googlegroups.com...
On May 21, 10:40 am, "Robert A. Macy" <m...@california.com> wrote:
> On May 20, 2:35 am, "Jeff Richards" <JRicha...@msn.com.au> wrote:
>
>
>
>
>
> > Google is your friend.http://support.microsoft.com/kb/306346
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Robert A. Macy" <m...@california.com> wrote in
> > messagenews:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...

>
> > > On one machine, running
> > > Win98 and MS Office 97

>
> > > on another machine, running
> > > WinXP and MS Office 2003

>
> > > using either machine, every now and then I need to print a 'folder' of
> > > documents

>
> > > Is there an easy way to set up for a SINGLE print statement to print
> > > all 100+ of these.

>
> > > I've historically clicked to open each one, then print each one, but
> > > when there's this many that gets a bit tedious.

>
> > > Sorry, for the wrong group, but I figure you guys know how to do
> > > this.

>
> > > Robert- Hide quoted text -

>
> > - Show quoted text -

>
> Gary,
>
> You're right about the system choking on 100+
>
> Jeff, those 'sequential' print macros look like EXACTLY what I need,
> thank you.
>
> Uh,... I can easily use a text editor to create such a macro, but what
> ending three letters should the file name have?
>
> And, how do I initiate the macro?
>
> Robert- Hide quoted text -
>
> - Show quoted text -


Sorry to reply to myself, but...

I found that *if* I open Word pull down Tools and then create a macro,
I get to creat a macro.

I called it PrintAll and placed all the text from Jeff's URL for Word
2003 print from a folder.

I created a file under My Documents called $Writing and placed
four .doc in there

After creating the macro and adding the directory name to the
appropriate place, I then saved the macro, closed the macro.

Then I opened Word again, called up the PrintAll macro and asked to
run it. ...NOTHING

Uh, what's going on here?

Robert
 
G

Gary S. Terhune

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

I'm outta here. Robert, you appear to have something to hide or you'd post
some sample lines, or the whole file (on some free webspace). You could even
email it to me and *I* would post it.

This kind of work, without a sample, is ridiculous. What is it about some
people that they ask and ask and ask (and ask and ask and ask) for help, but
won't do one thing to help us help them? Won't answer questions, won't
provide samples, won't go to the right newsgroup(s)...

Think about it, Robert. It shows a lot of disrespect on your part.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com


"Robert A. Macy" <macy@california.com> wrote in message
news:1c28dea3-0119-4726-84f4-e775fca0456d@w34g2000prm.googlegroups.com...
On May 21, 10:40 am, "Robert A. Macy" <m...@california.com> wrote:
> On May 20, 2:35 am, "Jeff Richards" <JRicha...@msn.com.au> wrote:
>
>
>
>
>
> > Google is your friend.http://support.microsoft.com/kb/306346
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Robert A. Macy" <m...@california.com> wrote in
> > messagenews:6ecfed99-416d-47c3-ad0c-43e789fafb54@z16g2000prn.googlegroups.com...

>
> > > On one machine, running
> > > Win98 and MS Office 97

>
> > > on another machine, running
> > > WinXP and MS Office 2003

>
> > > using either machine, every now and then I need to print a 'folder' of
> > > documents

>
> > > Is there an easy way to set up for a SINGLE print statement to print
> > > all 100+ of these.

>
> > > I've historically clicked to open each one, then print each one, but
> > > when there's this many that gets a bit tedious.

>
> > > Sorry, for the wrong group, but I figure you guys know how to do
> > > this.

>
> > > Robert- Hide quoted text -

>
> > - Show quoted text -

>
> Gary,
>
> You're right about the system choking on 100+
>
> Jeff, those 'sequential' print macros look like EXACTLY what I need,
> thank you.
>
> Uh,... I can easily use a text editor to create such a macro, but what
> ending three letters should the file name have?
>
> And, how do I initiate the macro?
>
> Robert- Hide quoted text -
>
> - Show quoted text -


Sorry to reply to myself, but...

I found that *if* I open Word pull down Tools and then create a macro,
I get to creat a macro.

I called it PrintAll and placed all the text from Jeff's URL for Word
2003 print from a folder.

I created a file under My Documents called $Writing and placed
four .doc in there

After creating the macro and adding the directory name to the
appropriate place, I then saved the macro, closed the macro.

Then I opened Word again, called up the PrintAll macro and asked to
run it. ...NOTHING

Uh, what's going on here?

Robert
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

I suspect your comment is actually meant for the silly one, who has (at
last) provided a sample.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Gary S. Terhune" <none> wrote in message
news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> I'm outta here. Robert, you appear to have something to hide or you'd post
> some sample lines, or the whole file (on some free webspace). You could
> even email it to me and *I* would post it.
>
 
G

Gary S. Terhune

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

No kidding! Sorry about that Robert. Belonged to the thread above. That's
what I get for using Jeff as a reference mark, <g>.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>I suspect your comment is actually meant for the silly one, who has (at
>last) provided a sample.
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "Gary S. Terhune" <none> wrote in message
> news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
>> I'm outta here. Robert, you appear to have something to hide or you'd
>> post some sample lines, or the whole file (on some free webspace). You
>> could even email it to me and *I* would post it.
>>

>
>
 
R

Robert A. Macy

Re: How do I print 100+ .doc from a SINGLE request? sorry for wronggroup

On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
> No kidding! Sorry about that Robert. Belonged to the thread above. That's
> what I get for using Jeff as a reference mark, <g>.
>
> --
> Gary S. Terhune
> MS-MVP Shell/Userwww.grystmill.com
>
> "Jeff Richards" <JRicha...@msn.com.au> wrote in message
>
> news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>
>
>
> >I suspect your comment is actually meant for the silly one, who has (at
> >last) provided a sample.
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Gary S. Terhune" <none> wrote in message
> >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> >> I'm outta here. Robert, you appear to have something to hide or you'd
> >> post some sample lines, or the whole file (on some free webspace). You
> >> could even email it to me and *I* would post it.- Hide quoted text -

>
> - Show quoted text -


Jeff, Gary,

the macro I use is a copy of the one at the URL, with the 'exact' path
in the computer to get me to the folder of .doc files

when I ran the macro in 'debug' mode, nothing happened [I don't know
how to make it step along], just stuck on the first line, the title
line.

Thank you for not flaming me here. I apologize for being in the wrong
group, but you have no idea how hard it is to navigate through the
myriad of usenet groups to find something close to what I need. Plus,
I definitely don't want Word on XP group, they'd just tell me to go
buy another Word software, or something.

For me, since Word is running on Win98, which probably has its own
quirks, I thought someone here might have gone through this and could
just say, "do this..." and I'd be done.

Do either of you have a copy of a macro that you have used
successfully on your Win98 OS? All I would have to do [maybe] is
change the file directory path and it should work.

Is there some literature that describes this macro language and
describes the steps to understand what's happening as the macro steps
along. For example, the phrase
while ( dir() )
[may have misquoted this line, but you have the gist]

Forgot to clarify: this system is Win98 with the application Word 97
another system is WinXP with the application Word 2003 with the
printer on a network.

Robert
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

I will have look at the macro and see what issues there might be. Note that
you must have the version that matches your version of WORD - 2003 I think
you said it was. Can you confirm the version of the macro and the version of
WORD, so we are on the same wavelength? Note also that this is not a W98
issue, it's a WORD issue so you should be able to get assistance in a WORD
group whatever OS you are running under (but then again, maybe not).

There is another way to do it, but not worth it if you do this regularly.
You use DIR > FileList.BAT at a command prompt to get a list of filenames,
you can then edit the file so that each line looks like

START /WAIT WORD /p filename.doc

and execute the batch file. I use a global search and replace to create the
list of file names with the correct command (see other thread). This assumes
that the /p option for WORD means print the file to the default printer and
exit. I am sure WORD used to have this type of parameter (the p is just a
guess) but now I can't confirm this. If you can find a command line
parameter that starts WORD, prints the named file and executes, then a batch
file like this is an option. If there's no such parameter you can implement
something similar using an autoexecute macro to print and exit, but if
you're going to do that why not debug the folder print macro.

Ill look at the macro and let you know.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Robert A. Macy" <macy@california.com> wrote in message
news:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
> No kidding! Sorry about that Robert. Belonged to the thread above. That's
> what I get for using Jeff as a reference mark, <g>.
>
> --
> Gary S. Terhune
> MS-MVP Shell/Userwww.grystmill.com
>
> "Jeff Richards" <JRicha...@msn.com.au> wrote in message
>
> news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>
>
>
> >I suspect your comment is actually meant for the silly one, who has (at
> >last) provided a sample.
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Gary S. Terhune" <none> wrote in message
> >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> >> I'm outta here. Robert, you appear to have something to hide or you'd
> >> post some sample lines, or the whole file (on some free webspace). You
> >> could even email it to me and *I* would post it.- Hide quoted text -

>
> - Show quoted text -


Jeff, Gary,

the macro I use is a copy of the one at the URL, with the 'exact' path
in the computer to get me to the folder of .doc files

when I ran the macro in 'debug' mode, nothing happened [I don't know
how to make it step along], just stuck on the first line, the title
line.

Thank you for not flaming me here. I apologize for being in the wrong
group, but you have no idea how hard it is to navigate through the
myriad of usenet groups to find something close to what I need. Plus,
I definitely don't want Word on XP group, they'd just tell me to go
buy another Word software, or something.

For me, since Word is running on Win98, which probably has its own
quirks, I thought someone here might have gone through this and could
just say, "do this..." and I'd be done.

Do either of you have a copy of a macro that you have used
successfully on your Win98 OS? All I would have to do [maybe] is
change the file directory path and it should work.

Is there some literature that describes this macro language and
describes the steps to understand what's happening as the macro steps
along. For example, the phrase
while ( dir() )
[may have misquoted this line, but you have the gist]

Forgot to clarify: this system is Win98 with the application Word 97
another system is WinXP with the application Word 2003 with the
printer on a network.

Robert
 
G

Gary S. Terhune

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

It's Word 97 on the Win98 machine, Word 2003 on his XP machine... I think he
wants it to run on the old one.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:uMuDhGVvIHA.4492@TK2MSFTNGP02.phx.gbl...
>I will have look at the macro and see what issues there might be. Note
>that you must have the version that matches your version of WORD - 2003 I
>think you said it was. Can you confirm the version of the macro and the
>version of WORD, so we are on the same wavelength? Note also that this is
>not a W98 issue, it's a WORD issue so you should be able to get assistance
>in a WORD group whatever OS you are running under (but then again, maybe
>not).
>
> There is another way to do it, but not worth it if you do this regularly.
> You use DIR > FileList.BAT at a command prompt to get a list of filenames,
> you can then edit the file so that each line looks like
>
> START /WAIT WORD /p filename.doc
>
> and execute the batch file. I use a global search and replace to create
> the list of file names with the correct command (see other thread). This
> assumes that the /p option for WORD means print the file to the default
> printer and exit. I am sure WORD used to have this type of parameter (the
> p is just a guess) but now I can't confirm this. If you can find a
> command line parameter that starts WORD, prints the named file and
> executes, then a batch file like this is an option. If there's no such
> parameter you can implement something similar using an autoexecute macro
> to print and exit, but if you're going to do that why not debug the folder
> print macro.
>
> Ill look at the macro and let you know.
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "Robert A. Macy" <macy@california.com> wrote in message
> news:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
> On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
>> No kidding! Sorry about that Robert. Belonged to the thread above. That's
>> what I get for using Jeff as a reference mark, <g>.
>>
>> --
>> Gary S. Terhune
>> MS-MVP Shell/Userwww.grystmill.com
>>
>> "Jeff Richards" <JRicha...@msn.com.au> wrote in message
>>
>> news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>>
>>
>>
>> >I suspect your comment is actually meant for the silly one, who has (at
>> >last) provided a sample.
>> > --
>> > Jeff Richards
>> > MS MVP (Windows - Shell/User)
>> > "Gary S. Terhune" <none> wrote in message
>> >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
>> >> I'm outta here. Robert, you appear to have something to hide or you'd
>> >> post some sample lines, or the whole file (on some free webspace). You
>> >> could even email it to me and *I* would post it.- Hide quoted text -

>>
>> - Show quoted text -

>
> Jeff, Gary,
>
> the macro I use is a copy of the one at the URL, with the 'exact' path
> in the computer to get me to the folder of .doc files
>
> when I ran the macro in 'debug' mode, nothing happened [I don't know
> how to make it step along], just stuck on the first line, the title
> line.
>
> Thank you for not flaming me here. I apologize for being in the wrong
> group, but you have no idea how hard it is to navigate through the
> myriad of usenet groups to find something close to what I need. Plus,
> I definitely don't want Word on XP group, they'd just tell me to go
> buy another Word software, or something.
>
> For me, since Word is running on Win98, which probably has its own
> quirks, I thought someone here might have gone through this and could
> just say, "do this..." and I'd be done.
>
> Do either of you have a copy of a macro that you have used
> successfully on your Win98 OS? All I would have to do [maybe] is
> change the file directory path and it should work.
>
> Is there some literature that describes this macro language and
> describes the steps to understand what's happening as the macro steps
> along. For example, the phrase
> while ( dir() )
> [may have misquoted this line, but you have the gist]
>
> Forgot to clarify: this system is Win98 with the application Word 97
> another system is WinXP with the application Word 2003 with the
> printer on a network.
>
> Robert
>
 
G

Gary S. Terhune

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

I've lost track, sort of, but while Jeff actually helps you, I thought maybe
you'd be interested in some references

While I played with them several years ago, I don't know that much about VBA
(the programming language used for macros). I know even less as to what has
changed since your version of Office came out, so any current instructional
material is liable to contain things that won't work for you. For VBS
scripting, my bible is the MSDN Library. Here's what I'm talking about, only
for the Office 2003 version of VBA:
http://msdn2.microsoft.com/en-us/library/aa272268(office.11).aspx

OS isn't the issue. The version of your Office apps is the issue. I have to
believe that MUCH of what is in that Reference is still the same as in the
days of your system. At least when it comes to general things like syntax.
But you'll have to play with it to find out.

And then there's Google.
http://www.google.com/search?q=macros+mvp
http://www.google.com/search?q=vba+reference
http://www.google.com/search?q=vba+reference+word+97

Newsgroups include
microsoft.public.word.word97vba

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com


"Robert A. Macy" <macy@california.com> wrote in message
news:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
> No kidding! Sorry about that Robert. Belonged to the thread above. That's
> what I get for using Jeff as a reference mark, <g>.
>
> --
> Gary S. Terhune
> MS-MVP Shell/Userwww.grystmill.com
>
> "Jeff Richards" <JRicha...@msn.com.au> wrote in message
>
> news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>
>
>
> >I suspect your comment is actually meant for the silly one, who has (at
> >last) provided a sample.
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Gary S. Terhune" <none> wrote in message
> >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> >> I'm outta here. Robert, you appear to have something to hide or you'd
> >> post some sample lines, or the whole file (on some free webspace). You
> >> could even email it to me and *I* would post it.- Hide quoted text -

>
> - Show quoted text -


Jeff, Gary,

the macro I use is a copy of the one at the URL, with the 'exact' path
in the computer to get me to the folder of .doc files

when I ran the macro in 'debug' mode, nothing happened [I don't know
how to make it step along], just stuck on the first line, the title
line.

Thank you for not flaming me here. I apologize for being in the wrong
group, but you have no idea how hard it is to navigate through the
myriad of usenet groups to find something close to what I need. Plus,
I definitely don't want Word on XP group, they'd just tell me to go
buy another Word software, or something.

For me, since Word is running on Win98, which probably has its own
quirks, I thought someone here might have gone through this and could
just say, "do this..." and I'd be done.

Do either of you have a copy of a macro that you have used
successfully on your Win98 OS? All I would have to do [maybe] is
change the file directory path and it should work.

Is there some literature that describes this macro language and
describes the steps to understand what's happening as the macro steps
along. For example, the phrase
while ( dir() )
[may have misquoted this line, but you have the gist]

Forgot to clarify: this system is Win98 with the application Word 97
another system is WinXP with the application Word 2003 with the
printer on a network.

Robert
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

OK. I tested the macro at that site with XP and WORD 2003 and it works fine
(there's not much to it that can go wrong). This is what I used:

Sub ListDocNamesInFolder()
Dim sMyDir As String
Dim sDocName As String
' The path to obtain the files.
sMyDir = "C:\My Documents\TestFolder\"
sDocName = Dir(sMyDir & "*.DOC")
While sDocName <> ""
' Print the file.
Application.PrintOut FileName:=sMyDir & sDocName
' Get next file name.
sDocName = Dir()
Wend
End Sub


I cut and pasted from the www site to help avoid typing errors. To test it
I set my default printer to a printer that prints to file (shouldn't make a
difference) and then ran it both line by line and just using Run and it
worked OK, creating three print files for the three dummy DOC files I put
into that folder.

To do it line by line choose Step Into and then press F8 to see it progress
through each line. You should be able to hover the mouse over the variable
names to see what they are currently set to (sDocName is the one of
interest). The only problem I can think of is leaving the "\" off the end
of the folder name, but when I tried this it simply exited without doing
anything.

To understand what's happening in the macro you need to know that when first
used DIR (<patthname>) returns the first matching file name, and then DIR()
returns the next matching name until it finally returns a blank name
indicating no more files.

Links to references for the macro language are provided at the bottom of the
page I quoted.

I then powered up the trusty Compaq portable with W98 and WORD 2000. I used
the following macro:

Sub ListDocNamesInFolder()
Dim sMyDir As String
Dim sDocName As String
' The path to obtain the files.
sMyDir = "C:\My Documents\"
sDocName = Dir(sMyDir & "*.DOC")
While sDocName <> ""
' Print the file.
Application.PrintOut FileName: = sDocName
' Get next file name.
sDocName = Dir()
Wend
End Sub

which seems to be the same as the WORD 2003 one, and using the same test
protocol it didn't work.

In fact, the above macro is not the same as the WORD 2003 one, and the
difference is critical. The line in the above macro that is
Application.PrintOut FileName: = sDocName
must be changed to
Application.PrintOut FileName:= sMyDir & sDocName
and then everything's OK. That's because the DIR() function is returning
the file name without the folder name, and the folder needs to be stuck on
the front of it.

I'm guessing the same error in the WORD 97 version will cause the same
problem, but I don't seem to have any machines with W98 and Word 97. I
don't think the behaviour of DIR() has changed over the years. Check which
version of the macro you are using and if necessary make the change noted
above and see what happens.
--
Jeff Richards
MS MVP (Windows - Shell/User)

"Robert A. Macy" <macy@california.com> wrote in message
news:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...

Jeff, Gary,

the macro I use is a copy of the one at the URL, with the 'exact' path
in the computer to get me to the folder of .doc files

when I ran the macro in 'debug' mode, nothing happened [I don't know
how to make it step along], just stuck on the first line, the title
line.

Thank you for not flaming me here. I apologize for being in the wrong
group, but you have no idea how hard it is to navigate through the
myriad of usenet groups to find something close to what I need. Plus,
I definitely don't want Word on XP group, they'd just tell me to go
buy another Word software, or something.

For me, since Word is running on Win98, which probably has its own
quirks, I thought someone here might have gone through this and could
just say, "do this..." and I'd be done.

Do either of you have a copy of a macro that you have used
successfully on your Win98 OS? All I would have to do [maybe] is
change the file directory path and it should work.

Is there some literature that describes this macro language and
describes the steps to understand what's happening as the macro steps
along. For example, the phrase
while ( dir() )
[may have misquoted this line, but you have the gist]

Forgot to clarify: this system is Win98 with the application Word 97
another system is WinXP with the application Word 2003 with the
printer on a network.

Robert
 
B

Brian A.

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

"Robert A. Macy" <macy@california.com> wrote in message
news:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
> No kidding! Sorry about that Robert. Belonged to the thread above. That's
> what I get for using Jeff as a reference mark, <g>.
>
> --
> Gary S. Terhune
> MS-MVP Shell/Userwww.grystmill.com
>
> "Jeff Richards" <JRicha...@msn.com.au> wrote in message
>
> news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...
>
>
>
> >I suspect your comment is actually meant for the silly one, who has (at
> >last) provided a sample.
> > --
> > Jeff Richards
> > MS MVP (Windows - Shell/User)
> > "Gary S. Terhune" <none> wrote in message
> >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> >> I'm outta here. Robert, you appear to have something to hide or you'd
> >> post some sample lines, or the whole file (on some free webspace). You
> >> could even email it to me and *I* would post it.- Hide quoted text -

>
> - Show quoted text -


Jeff, Gary,

the macro I use is a copy of the one at the URL, with the 'exact' path
in the computer to get me to the folder of .doc files

when I ran the macro in 'debug' mode, nothing happened [I don't know
how to make it step along], just stuck on the first line, the title
line.

Thank you for not flaming me here. I apologize for being in the wrong
group, but you have no idea how hard it is to navigate through the
myriad of usenet groups to find something close to what I need. Plus,
I definitely don't want Word on XP group, they'd just tell me to go
buy another Word software, or something.

For me, since Word is running on Win98, which probably has its own
quirks, I thought someone here might have gone through this and could
just say, "do this..." and I'd be done.

Do either of you have a copy of a macro that you have used
successfully on your Win98 OS? All I would have to do [maybe] is
change the file directory path and it should work.

Is there some literature that describes this macro language and
describes the steps to understand what's happening as the macro steps
along. For example, the phrase
while ( dir() )
[may have misquoted this line, but you have the gist]

Forgot to clarify: this system is Win98 with the application Word 97
another system is WinXP with the application Word 2003 with the
printer on a network.

Robert

Robert,

In 98 open one of your MS Word 97 .doc files or create a new .doc file.
On the menu bar click Tools > Macro > Macros... > Visual Basic Editor.
Click once on "Project (Your open .doc name)" to highlight it.
On the Menu bar click Insert > Module.
Type or copy/paste the below code into the Code window. **Note: Change the path
"E:\My Tests\" on the line sMyDir = to your actual path where your .doc files
are.

Sub PrintAllDocs()
Dim sMyDir As String
Dim sDocName As String

' The path to obtain the files.
sMyDir = "E:\My Tests\"
sDocName = Dir(sMyDir & "*.DOC")

While sDocName <> ""
' Print the file.
Application.PrintOut FileName: = sDocName
' Get next file name.
sDocName = Dir()
Wend
End Sub

Save your .doc file that contains the new module in the same directory/folder
that you have the .doc files you want to print.
Open the .doc file containing the module or any other .doc file which is in the
same directory/folder as the file with the module.
On the Menu bar click Tools > Macro > Macros....
Select the module you created that is listed in the Macro name list.
Click Run.



--


Brian A. Sesko { MS MVP_Windows Desktop User Experience }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://dts-l.com/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375
 
R

Robert A. Macy

Re: How do I print 100+ .doc from a SINGLE request? sorry for wronggroup

On May 24, 8:44 am, "Brian A." <gonefish'n@afarawaylake> wrote:
> "Robert A. Macy" <m...@california.com> wrote in messagenews:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
> On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
>
>
>
>
>
> > No kidding! Sorry about that Robert. Belonged to the thread above. That's
> > what I get for using Jeff as a reference mark, <g>.

>
> > --
> > Gary S. Terhune
> > MS-MVP Shell/Userwww.grystmill.com

>
> > "Jeff Richards" <JRicha...@msn.com.au> wrote in message

>
> >news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...

>
> > >I suspect your comment is actually meant for the silly one, who has (at
> > >last) provided a sample.
> > > --
> > > Jeff Richards
> > > MS MVP (Windows - Shell/User)
> > > "Gary S. Terhune" <none> wrote in message
> > >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> > >> I'm outta here. Robert, you appear to have something to hide or you'd
> > >> post some sample lines, or the whole file (on some free webspace). You
> > >> could even email it to me and *I* would post it.- Hide quoted text -

>
> > - Show quoted text -

>
> Jeff, Gary,
>
> the macro I use is a copy of the one at the URL, with the 'exact' path
> in the computer to get me to the folder of .doc files
>
> when I ran the macro in 'debug' mode, nothing happened [I don't know
> how to make it step along], just stuck on the first line, the title
> line.
>
> Thank you for not flaming me here.  I apologize for being in the wrong
> group, but you have no idea how hard it is to navigate through the
> myriad of usenet groups to find something close to what I need.  Plus,
> I definitely don't want Word on XP group, they'd just tell me to go
> buy another Word software, or something.
>
> For me, since Word is running on Win98, which probably has its own
> quirks, I thought someone here might have gone through this and could
> just say, "do this..." and I'd be done.
>
> Do either of you have a copy of a macro that you have used
> successfully on your Win98 OS?  All I would have to do [maybe] is
> change the file directory path and it should work.
>
> Is there some literature that describes this macro language and
> describes the steps to understand what's happening as the macro steps
> along.   For example, the phrase
> while ( dir() )
> [may have misquoted this line, but you have the gist]
>
> Forgot to clarify: this system is Win98 with the application Word 97
> another system is WinXP with the application Word 2003 with the
> printer on a network.
>
> Robert
>
>   Robert,
>
>   In 98 open one of your MS Word 97 .doc files or create a new .doc file..
> On the menu bar click Tools > Macro > Macros... > Visual Basic Editor.
> Click once on "Project (Your open .doc name)" to highlight it.
> On the Menu bar click Insert > Module.
> Type or copy/paste the below code into the Code window.  **Note: Change the path
> "E:\My Tests\" on the line sMyDir = to your actual path where your .doc files
> are.
>
> Sub PrintAllDocs()
>       Dim sMyDir As String
>       Dim sDocName As String
>
>       ' The path to obtain the files.
>       sMyDir = "E:\My Tests\"
>       sDocName = Dir(sMyDir & "*.DOC")
>
>       While sDocName <> ""
>          ' Print the file.
>          Application.PrintOut FileName: = sDocName
>          ' Get next file name.
>          sDocName = Dir()
>       Wend
>    End Sub
>
>   Save your .doc file that contains the new module in the same directory/folder
> that you have the .doc files you want to print.
> Open the .doc file containing the module or any other .doc file which is in the
> same directory/folder as the file with the module.
> On the Menu bar click Tools > Macro > Macros....
> Select the module you created that is listed in the Macro name list.
> Click Run.
>
> --
>
> Brian A. Sesko   { MS MVP_Windows Desktop User Experience }
> Conflicts start where information lacks.http://basconotw.mvps.org/
>
> Suggested posting do's/don'ts:  http://dts-l.com/goodpost.htm
> How to ask a question:  http://support.microsoft.com/kb/555375- Hide quoted text -
>
> - Show quoted text -


THANK YOU!

The macro PrintAll now works on the Win98 OS running Word 97, using
the Word 2000 version.

Thanks for the note regarding ending the filepat with \. By NOT
posting my code and 'thinking' my code was correct I had left off the
ending \ on the file path.

Thank you for the description it helped a great deal to understand the
sequence.

I did go to Microsoft URL and it downloaded something [flashplayer
update?] that bombed my system so badly I had to power off reboot and
clean a lot of pieces out [whatever that means] and reset things.

But now all seems ok.

Thanks again. I knew this group would yield the richest source of
information.

Robert
 
B

Brian A.

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

"Robert A. Macy" <macy@california.com> wrote in message
news:5637b54d-9226-46c9-859d-49b90939986f@g16g2000pri.googlegroups.com...
On May 24, 8:44 am, "Brian A." <gonefish'n@afarawaylake> wrote:
> "Robert A. Macy" <m...@california.com> wrote in
> messagenews:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
> On May 22, 2:12 am, "Gary S. Terhune" <none> wrote:
>
>
>
>
>
> > No kidding! Sorry about that Robert. Belonged to the thread above. That's
> > what I get for using Jeff as a reference mark, <g>.

>
> > --
> > Gary S. Terhune
> > MS-MVP Shell/Userwww.grystmill.com

>
> > "Jeff Richards" <JRicha...@msn.com.au> wrote in message

>
> >news:%233ATx29uIHA.548@TK2MSFTNGP06.phx.gbl...

>
> > >I suspect your comment is actually meant for the silly one, who has (at
> > >last) provided a sample.
> > > --
> > > Jeff Richards
> > > MS MVP (Windows - Shell/User)
> > > "Gary S. Terhune" <none> wrote in message
> > >news:O4LSil4uIHA.748@TK2MSFTNGP05.phx.gbl...
> > >> I'm outta here. Robert, you appear to have something to hide or you'd
> > >> post some sample lines, or the whole file (on some free webspace). You
> > >> could even email it to me and *I* would post it.- Hide quoted text -

>
> > - Show quoted text -

>
> Jeff, Gary,
>
> the macro I use is a copy of the one at the URL, with the 'exact' path
> in the computer to get me to the folder of .doc files
>
> when I ran the macro in 'debug' mode, nothing happened [I don't know
> how to make it step along], just stuck on the first line, the title
> line.
>
> Thank you for not flaming me here. I apologize for being in the wrong
> group, but you have no idea how hard it is to navigate through the
> myriad of usenet groups to find something close to what I need. Plus,
> I definitely don't want Word on XP group, they'd just tell me to go
> buy another Word software, or something.
>
> For me, since Word is running on Win98, which probably has its own
> quirks, I thought someone here might have gone through this and could
> just say, "do this..." and I'd be done.
>
> Do either of you have a copy of a macro that you have used
> successfully on your Win98 OS? All I would have to do [maybe] is
> change the file directory path and it should work.
>
> Is there some literature that describes this macro language and
> describes the steps to understand what's happening as the macro steps
> along. For example, the phrase
> while ( dir() )
> [may have misquoted this line, but you have the gist]
>
> Forgot to clarify: this system is Win98 with the application Word 97
> another system is WinXP with the application Word 2003 with the
> printer on a network.
>
> Robert
>
> Robert,
>
> In 98 open one of your MS Word 97 .doc files or create a new .doc file.
> On the menu bar click Tools > Macro > Macros... > Visual Basic Editor.
> Click once on "Project (Your open .doc name)" to highlight it.
> On the Menu bar click Insert > Module.
> Type or copy/paste the below code into the Code window. **Note: Change the
> path
> "E:\My Tests\" on the line sMyDir = to your actual path where your .doc files
> are.
>
> Sub PrintAllDocs()
> Dim sMyDir As String
> Dim sDocName As String
>
> ' The path to obtain the files.
> sMyDir = "E:\My Tests\"
> sDocName = Dir(sMyDir & "*.DOC")
>
> While sDocName <> ""
> ' Print the file.
> Application.PrintOut FileName: = sDocName
> ' Get next file name.
> sDocName = Dir()
> Wend
> End Sub
>
> Save your .doc file that contains the new module in the same directory/folder
> that you have the .doc files you want to print.
> Open the .doc file containing the module or any other .doc file which is in
> the
> same directory/folder as the file with the module.
> On the Menu bar click Tools > Macro > Macros....
> Select the module you created that is listed in the Macro name list.
> Click Run.
>
> --
>
> Brian A. Sesko { MS MVP_Windows Desktop User Experience }
> Conflicts start where information lacks.http://basconotw.mvps.org/
>
> Suggested posting do's/don'ts: http://dts-l.com/goodpost.htm
> How to ask a question: http://support.microsoft.com/kb/555375- Hide quoted
> text -
>
> - Show quoted text -


THANK YOU!

The macro PrintAll now works on the Win98 OS running Word 97, using
the Word 2000 version.

Thanks for the note regarding ending the filepat with \. By NOT
posting my code and 'thinking' my code was correct I had left off the
ending \ on the file path.

Thank you for the description it helped a great deal to understand the
sequence.

I did go to Microsoft URL and it downloaded something [flashplayer
update?] that bombed my system so badly I had to power off reboot and
clean a lot of pieces out [whatever that means] and reset things.

But now all seems ok.

Thanks again. I knew this group would yield the richest source of
information.

Robert

You're quite welcome, glad to see you have it running. Yep, without the
trailing backslash it won't print, it will just return back to the doc.
Have fun and enjoy.


--


Brian A. Sesko { MS MVP_Windows Desktop User Experience }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://dts-l.com/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375
 
J

Jeff Richards

Re: How do I print 100+ .doc from a SINGLE request? sorry for wrong group

Thanks for letting us know that you got it sorted out.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Robert A. Macy" <macy@california.com> wrote in message
news:5637b54d-9226-46c9-859d-49b90939986f@g16g2000pri.googlegroups.com...
On May 24, 8:44 am, "Brian A." <gonefish'n@afarawaylake> wrote:
> "Robert A. Macy" <m...@california.com> wrote in
> messagenews:08884fdf-8b9d-4a94-90b9-e33be902d32c@s33g2000pri.googlegroups.com...
> snip <


THANK YOU!

The macro PrintAll now works on the Win98 OS running Word 97, using
the Word 2000 version.

Thanks for the note regarding ending the filepat with \. By NOT
posting my code and 'thinking' my code was correct I had left off the
ending \ on the file path.

Thank you for the description it helped a great deal to understand the
sequence.

I did go to Microsoft URL and it downloaded something [flashplayer
update?] that bombed my system so badly I had to power off reboot and
clean a lot of pieces out [whatever that means] and reset things.

But now all seems ok.

Thanks again. I knew this group would yield the richest source of
information.

Robert
 
Back
Top Bottom