Jump to content

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


Recommended Posts

Guest Robert A. Macy
Posted

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

Guest Gary S. Terhune
Posted

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

 

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

http://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

Guest Jeff Richards
Posted

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

 

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

Guest Robert A. Macy
Posted

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

 

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

Guest Robert A. Macy
Posted

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

 

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

Guest Jeff Richards
Posted

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

 

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

Guest Gary S. Terhune
Posted

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

 

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

http://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

Guest Jeff Richards
Posted

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

 

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.

>

Guest Gary S. Terhune
Posted

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

 

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

http://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.

>>

>

>

Guest Robert A. Macy
Posted

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

 

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

Guest Jeff Richards
Posted

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

 

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

Guest Gary S. Terhune
Posted

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

 

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

http://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

>

Guest Gary S. Terhune
Posted

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

 

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%28office.11%29.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

http://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

Guest Jeff Richards
Posted

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

 

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

Guest Brian A.
Posted

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

 

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

Guest Robert A. Macy
Posted

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

 

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

Guest Brian A.
Posted

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

 

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

Guest Jeff Richards
Posted

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

 

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

×
×
  • Create New...