Solved

Issue with network printing and macros

Posted on 2012-03-30
5
344 Views
Last Modified: 2012-06-21
We have a system where the users can all print to the big network printers and it will store it in the user mailbox's for printing later. the printers are shared off the server (server 2008 r2).

We have macros set up so that specific functions are used (i.e. print from certain trays, duplexed etc) These macros are the same for everyone in this office, and they work well except for one user who is getting a debug error on the macro on the line

 ActivePrinter = "\\MAINSERVER\Network Printer 1"

We have tried:
switching her machine for another one - same issue
different network port / cables - same issue
new profile - same issue
different user logged on - same issue

the odd thing is, moving the old machine to a different room, the macro works fine!
0
Comment
Question by:Neal58
  • 3
  • 2
5 Comments
 
LVL 41

Assisted Solution

by:dlmille
dlmille earned 250 total points
ID: 37789825
Outside of Excel, can you change printers using the control panel/printers option?  can you change to the active printer manually?  In either room?


Put this in a public module in Excel and run the macro.  Is that printer you want to print to listed?

'Source from rorya on E-E:
Sub PrintersAndPorts()

'This works with Windows 2000 and up

   Dim Arr               As Variant
   Dim Device            As Variant
   Dim Devices           As Variant
   Dim msg               As String
   Dim RegObj            As Object
   Dim RegValue          As String
   Const HKEY_CURRENT_USER = &H80000001

   Set RegObj = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\default:StdRegProv")
   RegObj.enumvalues HKEY_CURRENT_USER, "Software\Microsoft\Windows NT\CurrentVersion\Devices", Devices, Arr

   For Each Device In Devices
      RegObj.getstringvalue HKEY_CURRENT_USER, "Software\Microsoft\Windows NT\CurrentVersion\Devices", Device, RegValue
      msg = msg & Device & " on " & Split(RegValue, ",")(1) & vbCrLf
   Next

   MsgBox msg, vbInformation, "Printers and Ports"

End Sub

Open in new window


Dave
0
 
LVL 4

Author Comment

by:Neal58
ID: 37832207
sorry for the lapse in this. Only now able to do this. will update with the results tomorrow afternoon.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37900878
@Neal58 - any success?

Dave
0
 
LVL 4

Accepted Solution

by:
Neal58 earned 0 total points
ID: 37909832
late answer but we can only ascertain that the second PC has some fault in it. Even doing a reformat and reinstall of everything the issue still happens.

using other PC's in the locality with this network port brought no issues; and unlike the original PC, moving this one to a different location still has the same problem!

Sadly the practice manager on site likes to try everything himself and not tell me the results of any tests I ask for, so I am leaving this with him to muddle with.
0
 
LVL 4

Author Closing Comment

by:Neal58
ID: 37932183
points for the help.

half sorted but uncooperative department manager means that I am not going to pursue this in any haste
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now