Help Why would the same Excel VBA work different in different computers

We have the same excel with VBA modifications in over 5 PC.  We have noticed that 2 PC are not reacting the same as the other 3.  This makes us think that it may be Excel perse.

How can we identify if one Excel (not the workbook because its the same) different from another PC (see pic of error).

The VBA has stopped in different lines, but with EE assistance we git to fix it.  Now its another error (see pic)
rayluvsAsked:
Who is Participating?
 
GrahamSkanRetiredCommented:
The second error could be caused by a difference in the printer or printer driver.
0
 
GrahamSkanRetiredCommented:
No pic.

Post the code and tell us the error and code line.
0
 
VipulKadiaCommented:
Hi Ramante,
Where are the pics???
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
rayluvsAuthor Commented:
The 2 errors that appear are:

          Runtime error 1004
          using advance filter, select range

          Runtime error 1004
          Cannot asigne properties PriuntQuality class PageSetup

Surely is the Excel; where can we check
FilterError.jpg
PageError.jpg
0
 
rayluvsAuthor Commented:
Do you mean that all PC should have the same exact  printer drivers?
0
 
ScriptAddictCommented:
So, just to confirm all 5 of the workstations are using the same operating system and version of Excel, with all the patches/updates installed?

-SA
0
 
GrahamSkanRetiredCommented:
I mean that the setting for one printer driver might not be appropriate for another driver. PrintQuality is documented as one of those properties.

With my printer that setting gives a run-time error (1004 application-defined),  but it accepts 360

ActiveSheet.PageSetup.PrintQuality = 600 'Error 1004

ActiveSheet.PageSetup.PrintQuality = 360 'OK
0
 
rayluvsAuthor Commented:
ScriptAddict:

   All PC are using the same MS Office version (verified).  3 have Windows XP, 1 Vista, 1 Windows 7

GrahamSkan:

  It seems that the solution should be that all have the same printer drivers compatible to thier OS
  installed.  Correct?

0
 
ScriptAddictCommented:
What OS are the two computers that are giving you problems?
0
 
GrahamSkanRetiredCommented:
Any such setting should be acceptable to all the printer drivers. Choosing the wrong printer could give the fault to all of them. Is the setting really necessary - most would just let it default?
0
 
rayluvsAuthor Commented:
OS =  3 have Windows XP, 1 Vista, 1 Windows 7

We can check if the setting is necessary.  We understand its a must, but we'll check with users.
0
 
ScriptAddictCommented:
You had mentioned that two of the PC's are acting different then the other three.  What are the OS of the two that are acting differently then the other three?
0
 
rayluvsAuthor Commented:
XP and prior, one was Vista.  When we compare the Excel options between all PC and sync it with the PC that works, the Vista was fixed.  The XPs are still with the problem.
0
 
rayluvsAuthor Commented:
We have come back to complete solving this problem on friday will keep you informed.
0
 
rayluvsAuthor Commented:
hi all.  Unfortunately we have not been able to go to the office to verify the printer driver and the user there are not technically inclined.  We'll check it when we get the and give u guys feedback.
0
 
rayluvsAuthor Commented:
Somehow the problem stopped and the IT guy doesn't even know what he did.  We'll proceed to close question.
0
 
rayluvsAuthor Commented:
Thanx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.