Greetings,

I need to have a form printed on the same printer regardless of which
work station is trying to print it. I have 5 work stations in my LAN
each with it's own printer. Only one of these printers can print the
entire form and the print process is initiated by CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman

I got something like this when I recorded a macro to select a printer:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Symantec Fax Starter Edition on Ne00:", Collate:=True
Mike F
"Minitman" wrote in message
...
Greetings,

I need to have a form printed on the same printer regardless of which
work station is trying to print it. I have 5 work stations in my LAN
each with it's own printer. Only one of these printers can print the
entire form and the print process is initiated by CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman

hi
this is from my network. i don't know how your's is set up
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\OKI-01\OKI-HP4000-01 on Ne01:", Collate:=True
regards
Frank

-----Original Message-----
Greetings,

I need to have a form printed on the same printer
regardless of which
work station is trying to print it. I have 5 work
stations in my LAN
each with it's own printer. Only one of these printers
can print the
entire form and the print process is initiated by
CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct
printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman
.

Hey Mike and Frank,

Thanks for the replies, however your solutions were to specific to
your machines, but they did show me a different direction to take.

It turns out the simple answer is to use the macro recorder and just
setup the printer I needed from a work station that was not connected
to it. This gave me the following command, address and printer name
with syntax:

Application.ActivePrinter = "\\BLIND\hp deskjet 5100 series on Ne01:"

Again, thanks.

-Minitman


On Thu, 21 Oct 2004 05:03:56 -0700, "Frank Stone"
wrote:

hi
this is from my network. i don't know how your's is set up
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\OKI-01\OKI-HP4000-01 on Ne01:", Collate:=True
regards
Frank

-----Original Message-----
Greetings,

I need to have a form printed on the same printer
regardless of which
work station is trying to print it. I have 5 work
stations in my LAN
each with it's own printer. Only one of these printers
can print the
entire form and the print process is initiated by
CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct
printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman
.

Or on a workstation that was connected, you could go to the immediate window
in the VBE and do

? Application.ActivePrinter

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
...
Hey Mike and Frank,

Thanks for the replies, however your solutions were to specific to
your machines, but they did show me a different direction to take.

It turns out the simple answer is to use the macro recorder and just
setup the printer I needed from a work station that was not connected
to it. This gave me the following command, address and printer name
with syntax:

Application.ActivePrinter = "\\BLIND\hp deskjet 5100 series on Ne01:"

Again, thanks.

-Minitman


On Thu, 21 Oct 2004 05:03:56 -0700, "Frank Stone"
wrote:

hi
this is from my network. i don't know how your's is set up
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\OKI-01\OKI-HP4000-01 on Ne01:", Collate:=True
regards
Frank

-----Original Message-----
Greetings,

I need to have a form printed on the same printer
regardless of which
work station is trying to print it. I have 5 work
stations in my LAN
each with it's own printer. Only one of these printers
can print the
entire form and the print process is initiated by
CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct
printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman
.