![]() ![]() ![]() instead of them saving by going to File - Save or cntrl+s ? I just thought that MAYBE having a big button in their face will remind them. How to I create a macro button at the top of the page that is literally a SAVE button. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a "refreshed" copy of the workbook before they start writing in cells that already contain information. We have a "shared" work book we all work in. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc. I have been trying to learn macros but have not made one yet. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |