sunilvedula Posted December 19, 2007 Report Share Posted December 19, 2007 i want the macro to print the documents from a folder and many such folders. For eg a folder "My documents" contains numerous folders and i want the macro to print all the documents in all the folders. Approximately i have to print around 200 folders everday with atleast 2 documents in each folder. Please help and suggest me as to how to do that? Quote Link to comment Share on other sites More sharing options...
kevin Posted December 19, 2007 Report Share Posted December 19, 2007 This can be done with Macro Express but Macro Express does not perform the print. It automates calling the application(s) that print the document(s). Here is a discussion that discusses how this works: Launch program to print a file. To summarize, use the Repeat with Folder command to find the files in the folders and then call the application to print the document(s). Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted December 20, 2007 Author Report Share Posted December 20, 2007 This can be done with Macro Express but Macro Express does not perform the print. It automates calling the application(s) that print the document(s). Here is a discussion that discusses how this works: Launch program to print a file. To summarize, use the Repeat with Folder command to find the files in the folders and then call the application to print the document(s). thanks i think it should work. Let me see. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted December 20, 2007 Author Report Share Posted December 20, 2007 i have written the code but i think it is not printing on its own. Could anyone help me. Quote Link to comment Share on other sites More sharing options...
Cory Posted January 11, 2008 Report Share Posted January 11, 2008 I could give it a shot. To start with what type of documents are you printing? Once we get a print command line to work for you then we can move on to the rest. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted January 16, 2008 Author Report Share Posted January 16, 2008 hi thanks for the reply. i want to print word, excel and pdf documents Quote Link to comment Share on other sites More sharing options...
Cory Posted February 5, 2008 Report Share Posted February 5, 2008 Check back thru the posts as there is a good writeup on using the VBA macro to print Word docs. Excel I'm not sure about but it may be similar. And as for PDF you can check out my writeup on it on my webpage. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted February 11, 2008 Author Report Share Posted February 11, 2008 I could give it a shot. To start with what type of documents are you printing? Once we get a print command line to work for you then we can move on to the rest. I need to print word, excel and pdf documents. They have to be printed accoridng to the folder wise. i..e there will be around 40 folders and it has to complete one foldr and then move on to others. Quote Link to comment Share on other sites More sharing options...
Cory Posted February 13, 2008 Report Share Posted February 13, 2008 Sure. All you need to do is use a condition on the file type. You could use and "If" or a "Switch/Case". In aech one you would have a different routine for the different file types by extension. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.