jana
asked on
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)
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)
Hi Ramante,
Where are the pics???
Where are the pics???
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do you mean that all PC should have the same exact printer drivers?
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
-SA
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
What OS are the two computers that are giving you problems?
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?
ASKER
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.
We can check if the setting is necessary. We understand its a must, but we'll check with users.
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?
ASKER
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.
ASKER
We have come back to complete solving this problem on friday will keep you informed.
ASKER
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.
ASKER
Somehow the problem stopped and the IT guy doesn't even know what he did. We'll proceed to close question.
ASKER
Thanx
Post the code and tell us the error and code line.