Hi everyone

Here I am again looking for help.....

I have a reasonable well functioning code that does almost everything I
need, with one exception.

5 different people access this file and print the same report, the glitch is
that they each are assigned a different Printer Port (Via the Citrix Server)
to the printer in our office.

I was toying / hoping I could use a pup up with the 5 options for each to
select their printer ports and have that inserted into the module into the
section of code so that the Macro would run it's course.

Really looking forward to your suggestions and Ideas.

Cheers

TIA
Mick

Vacuum Sealed brought next idea :
Hi everyone

Here I am again looking for help.....

I have a reasonable well functioning code that does almost everything I
need, with one exception.

5 different people access this file and print the same report, the glitch
is that they each are assigned a different Printer Port (Via the Citrix
Server) to the printer in our office.

I was toying / hoping I could use a pup up with the 5 options for each to
select their printer ports and have that inserted into the module into the
section of code so that the Macro would run it's course.

Really looking forward to your suggestions and Ideas.

Cheers

TIA
Mick

Normally, Excel defaults to whatever printer the user has set to be
their default printer. Would this then not be their respective printer
port location?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Vacuum Sealed brought next idea :
Hi everyone

Here I am again looking for help.....

I have a reasonable well functioning code that does almost everything I need,
with one exception.

5 different people access this file and print the same report, the glitch is
that they each are assigned a different Printer Port (Via the Citrix Server)
to the printer in our office.

I was toying / hoping I could use a pup up with the 5 options for each to
select their printer ports and have that inserted into the module into the
section of code so that the Macro would run it's course.

Really looking forward to your suggestions and Ideas.

Cheers

TIA
Mick

Normally, Excel defaults to whatever printer the user has set to be
their default printer. Would this then not be their respective printer
port location?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi Garry and thx,

As a general rule over a standard network yes, but the company uses a
Web-Based Citrix server cluster (which I hate intensely)...

Essentially, it is a bank of 5 servers, 4 slave and 1 master controller, the
Master controller, will allocate a different server depending on the load
each server is under, each of those servers has a copy of MSOffice,
conversely, each server has it's own printer port allocation, it is a
roullette wheel to get the same port address.

I can have 5 different people log in using my computer and have a different
port setting for each.

Not to worry, will have to persist with manually changing the settings in
the VBE....

Thx again...
Mick

Vacuum Sealed was thinking very hard :
Hi Garry and thx,

As a general rule over a standard network yes, but the company uses a
Web-Based Citrix server cluster (which I hate intensely)...

Essentially, it is a bank of 5 servers, 4 slave and 1 master controller, the
Master controller, will allocate a different server depending on the load
each server is under, each of those servers has a copy of MSOffice,
conversely, each server has it's own printer port allocation, it is a
roullette wheel to get the same port address.

I can have 5 different people log in using my computer and have a different
port setting for each.

Not to worry, will have to persist with manually changing the settings in the
VBE....

Thx again...
Mick

In this case, if 5 people 'log in' using your computer to run MSO from
whatever server they happen to 'catch' at login, would that MSO's
default printer not be the one assigned to that server?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi Garry

I would have thought so too.

I tried removing th specific end section of the path (:NE##) and just used
\\Network\DefaultPrinter but the routine haulted on it, seems I need to
specify the extra bit at the end..

eg

:NE00
:NE01
:NE02
:NE03
:NE04

I am open to alternatives

Cheers
Mick


If I don't have this included, the routine stops

Vacuum Sealed presented the following explanation :
Hi Garry

I would have thought so too.

I tried removing th specific end section of the path (:NE##) and just used
\\Network\DefaultPrinter but the routine haulted on it, seems I need to
specify the extra bit at the end..

eg

:NE00
:NE01
:NE02
:NE03
:NE04

I am open to alternatives

Cheers
Mick


If I don't have this included, the routine stops

Ok, I guess I still haven't made my point clear. Sorry about that! Let
me try once again...

When a MSO app starts up it establishes a connection to its default
printer. There should be no need to ever specify a printer for any
printout unless it's not to go to the default printer. IOW, Excel knows
where the printer is because it already established connection to it at
startup, so just using PrintOut should work without issue.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc