List of available printers form?
 

I am trying to develop a VBA form that will dynamically find and list
all available printers (local and network) including the default
printer. This would be the same list appearing in the Print
Configuration window in Excel. From this VBA form I would select which
printer will be assigned to Application.ActivePrinter in a macro. How
could this be done?

List of available printers form?
 

pls do not multi post. See ans in other post.

--
Don Guillett
SalesAid Software

"prizm1" wrote in message
...
I am trying to develop a VBA form that will dynamically find and list
all available printers (local and network) including the default
printer. This would be the same list appearing in the Print
Configuration window in Excel. From this VBA form I would select which
printer will be assigned to Application.ActivePrinter in a macro. How
could this be done?

List of available printers form?
 

don:

where's the other post so we can view the response?

--


Gary


"Don Guillett" wrote in message
...
pls do not multi post. See ans in other post.

--
Don Guillett
SalesAid Software

"prizm1" wrote in message
...
I am trying to develop a VBA form that will dynamically find and list
all available printers (local and network) including the default
printer. This would be the same list appearing in the Print
Configuration window in Excel. From this VBA form I would select which
printer will be assigned to Application.ActivePrinter in a macro. How
could this be done?

List of available printers form?
 

newusers

--
Don Guillett
SalesAid Software

"Gary Keramidas" wrote in message
...
don:

where's the other post so we can view the response?

--


Gary


"Don Guillett" wrote in message
...
pls do not multi post. See ans in other post.

--
Don Guillett
SalesAid Software

"prizm1" wrote in message
...
I am trying to develop a VBA form that will dynamically find and list
all available printers (local and network) including the default
printer. This would be the same list appearing in the Print
Configuration window in Excel. From this VBA form I would select which
printer will be assigned to Application.ActivePrinter in a macro. How
could this be done?

List of available printers form?
 

thanks, don. got it.

--


Gary


"Don Guillett" wrote in message
...
newusers

--
Don Guillett
SalesAid Software

"Gary Keramidas" wrote in message
...
don:

where's the other post so we can view the response?

--


Gary


"Don Guillett" wrote in message
...
pls do not multi post. See ans in other post.

--
Don Guillett
SalesAid Software

"prizm1" wrote in message
...
I am trying to develop a VBA form that will dynamically find and list
all available printers (local and network) including the default
printer. This would be the same list appearing in the Print
Configuration window in Excel. From this VBA form I would select which
printer will be assigned to Application.ActivePrinter in a macro. How
could this be done?