×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

(OP)
Please HELP! Hi there- previous mainframe (Assembler and Cobol) programmer turned small business store owner. My EXCEL VB code that has worked perfectly errors now because of two AI MS pop up windows. MS has this forced with no way to remove it in my settings. I created a VB Excel macro that logs into a website and moves data from excel into the website forms. A popup keeps occurring with MS Edge then the macro pauses permanently. I have made many unsuccessful attempts to remove the toolbar and popups in my MS Edge settings and advanced settings...it appears to be related to new AI code MS has defaulted when accessing MS Edge. I just simply need to simulate the enter key (to remove first popup) then wait 3 seconds and simulate the enter key (to remove 2nd popup) then proceed with my logon code.
My code (that pops up after the website "Obj.Get"

Sub TestEdgeAuto()

Dim Obj As New WebDriver
Obj.Start "edge", ""
Obj.Get "https://bluebelle.consignoraccess.com//login" <====this is when I need to simulate the ENTER key and wait 3 seconds to simulate the ENTER key again after 3 seconds.
Obj.FindElementByName("consignorId").SendKeys ("1002")

RE: Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

How about using SendKeys ?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

He is using SendKeys.

Macola and SAP Business One Consultant
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups

Erm ... when I use the URL ( https://bluebelle.consignoraccess.com//login) directly there are no popups. Goes straight to the login screen.

And when I run your code*, it works as I'd expect. Can yopu perhaps be a little more exp0lixit about the problem you are getting, any error messages, etc.

* I am assuming that you are using SeleniumBasic with the correct Edgedriver version

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close