Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 595
Default vba printing using a printer with citix connection NE:-Problem

On Thu, 24 Jul 2008 00:51:14 -0700, Thomas Dettenberg wrote:

You can check the NE-ID (value 1 - 99)
using the following code:
your printer is for example: "HP-LJ-6"

sub ne_search ()
dim ne as sting, printer$, i%

printer = "HP-LJ-6"
on error resume next
for i = 1 to 99
ne = vba.format(i,"00")
err.number = 0
application.activeprinter = printer & ne & ":"

if err.number = 0 then
exit for
end if
next

end sub


Here are a couple more options (though not necessarily better than yours)

http://www.dailydoseofexcel.com/arch...-printer-port/
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printer Using USB Port Slows Page Setup Stu B Excel Discussion (Misc queries) 3 April 22nd 10 12:45 PM
printer port assignment in macro DaveAlbany Excel Programming 3 August 11th 06 04:39 PM
Capturing Data from a Com Port or Printer Port Newby :) Excel Programming 3 August 19th 05 01:54 PM
active printer Gixxer_J_97[_2_] Excel Programming 2 June 29th 05 02:24 PM
Active printer Marijan Glavac Excel Programming 1 September 29th 04 01:41 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"