Hi,
I wanted to create a macro that will connect and give print command to the network printer (not the default ) and need to rearrange the page setup also.
if anybody knows any useful link regarding this will be very helpful for me
thanks and regards
nowfal
is it always going to be same printer you want to connect to?
if so just change the file path in the below code
if this does not work check this outCode:Application.ActivePrinter = "\\prnl030s.VIA.NOVONET\PR000318 on Ne08:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "\\prnl030s.VIA.NOVONET\PR000318 on Ne08:", Collate:=True
HTML Code:http://exceltips.vitalnews.com/Pages/T0548_Controlling_the_Printer_in_a_Macro.html
Last edited by JR@SGC; 08-24-2007 at 07:39 AM.
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
thanks for your reply, i have to check with my office network tomorrow
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks