![]() ![]() There is a setting somewhere on the machine causing this or the refresh would not have an effect. That takes care of the problem but it also forces the user set their machine up again to the way they had it before and reinstall all of the software and everything. ![]() A clean refresh including the operating system. The only way we can solve it is to have IT completely reload everything on the hard drive. In my case I have not found a solution otherwise I would not be asking here. Unfortunately run-time error 70 seems to be a catch all and a lot of users report the error for different symptoms. I have googled and googled and googled and googled. All computers are set up the same way here, same specs, same software. Therefore, it is likely a registry setting on the local machine or something like that. But the same user can use a different computer and everything is fine. What I mean is on the culprit computers nobody can automate no matter which user logs in. It is not a user issue, but a computer issue. Something is causing random people to not be able to automate internet explorer. We use Windows XP, Internet Explorer 7, and Office 2003. So please do not ask "why do you want to do a goodle search?" and please do not ask "what are you trying to do". This is just a simple example of the problem (we are actually automating much more complex tasks). Running as administrator does not help either. ![]() I have tried using CreateObject and all that stuff. I know there are other ways to declare the internet explorer object. It is NOT a timing issue (I still get the error even if I step through manually). This macro works on 9 out of 10 computers. The error states Run-time error 70: 'Permission Denied' IE.document.Forms(0).Submit <- This line results in error. IE.document.getElementsByTagName("Input")(3).Value = "Search Term" ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |