I've made sure that screenupdating is turned back on at the end of every procedure.
I can't think of anything in my macro that would have these kinds of effects. I don't understand what's going on at all. So if I press "s' it will input "ss" into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. I have a fairly lengthy macro that works perfectly most of the time. I've been having a strange problem lately. Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! Summa summarum - it could be an idea to check whether the two machines have different version numbers for the MSCOMCT2.OCX files. Regsvr32 c:\windows\system32\MSCOMCT2.OCX (not sure if this was necessary, but I didn't think it could hurt). Regsvr32 /u c:\windows\system32\MSCOMCT2.OCX Then, finally I unregistered the old DLL via I then rebooted the machine - still no luck. I then copied the MSCOMCT2.* files from work, made a backup of them at home and copied those from work to my C-drive (Windows XP - c:\windows\system32\ ). I had a light-bulb moment and wondered whether there was a difference in the version numbers for MSCOMCT2.OCX at work and at home. My problem was that a userform defined with Excel at work (containing DT pickers) gave the message in the title when opening it at home. Thought I'd append my experience of the above problem - you can find all sorts of references to it everywhere. document.getelementbyid("fPassword").Value = " Password " document.getelementbyid("fUserName").Value = " UserName " Set appIE = CreateObject("InternetExplorer.Application") The link is: ĭim appIE As Object ' InternetExplorer.Application
I highlighted another section in green that I took from a previous post hoping it would solve my problem. The code runs without errors, but doesn't actually "hit" the submit button on the webpage.įor posting, I removed my actual user name and password and and used the generic " User Name " and " Password " highlighted in blue. So far I can get everything to work besides the Submit part. I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button.
0 kommentar(er)
