Guest Robert A. Macy Posted May 19, 2008 Posted May 19, 2008 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 May 20, 2008 Posted May 20, 2008 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 May 20, 2008 Posted May 20, 2008 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 May 21, 2008 Posted May 21, 2008 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 May 21, 2008 Posted May 21, 2008 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 May 21, 2008 Posted May 21, 2008 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 May 21, 2008 Posted May 21, 2008 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 May 22, 2008 Posted May 22, 2008 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 May 22, 2008 Posted May 22, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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 May 24, 2008 Posted May 24, 2008 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
Recommended Posts