Print Macro

[Piotrwilczak]

Hello

We are using the macro below to print a copy on Plain and Letterhead at the same time . The application which we use is on remote server and our print server is on local network ( I think we use something called Remote Desktop Easy Print which kind of redirects the print job from the server on which the application reside to print server in our office). For the macro to work we have to edit it and change the redirected values every day.
Is there a way to edit this macro to specify the range of numbers (lets say from 1 to 65,000) no matter to which number printing is redirected macro would still work?



Sub Macro1()
'
' Macro1 Macro
'
'
ActivePrinter = _
"TCL012 - Team A - Headed on abctclfls001 (redirected 613)"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentWithMarkup, Copies:=1, Pages:="", PageType:= _
wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
ActivePrinter = "TCL012-Team A on abctclfls001 (redirected 613)"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentWithMarkup, Copies:=1, Pages:="", PageType:= _
wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
End Sub

I would be grateful if you could assist .

Thank You


Piotr

 

[rlv01]

The problem is not can you code something, the problem is *what* to code. There has to be a method for the macro to retreive information about what the daily redirection is. Having a list of 65,000 entries that you sequentially try is not the solution. Better to figure out a way to have Remote Desktop Easy Print write the daily redirect to a file that you could then read with VBA. Btw, you're aware that this is a Word VBA question, not Excel. Forum Rule #4 prevents me from being specific, but there are web resources dedicated to Word VBA.

 

[Piotrwilczak]

Hi rlv01

Thank You very much for your reply . I thought that VBA work the same for Word and Excel ?
Anyways once again thank you for your help .

Regards

Piotr