![]() ![]() Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site). We are here to help so help us to help you! We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.Įxpect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.Ĭross-posting is when you post the same question in other forums on the web. Your post does not comply with Rule 8 of our Forum RULES. We all follow these rules for the benefit of all, as must you. ![]() Please stop and take a moment to read them now. When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. I have no VBA skills, otherwise I am a decent excel user, so if the talk gets really technical I would be very grateful if you took the time to explain the code a little, makes it much easier later to understand what's actually happening and find a solution, Thanks! What would be the easiest way to fill it out? Do I have to put some difficult code so I could grab form field names or maybe just a code that detects first field, enters first field from excel, then goes on to second and so on? So you see Lp source of material, Lp logs of price and so on, i would form the required excel data in a simpler form so it is the same as this form, 2 columns, A for name, B for value, just identical. All entered fields are either text or numbers. The only dropdown field is the first, currency, which by default is ok so can skip that. Obviously there's more fields down there, but the generally it just looks like this, field after field. When you’re done entering your info, at the bottom, tap Done. ![]() Add, edit, or delete info: Add: At the bottom, tap Add. To the right of the address bar, tap More. On your Android phone or tablet, open the Chrome app. Unfortunately this form is in a secure web locked out so can't share the link for you to see for yourself, if needed please ask what else you need, the url is formed for each product differently (slight change to item number, but I hope there is a way doing this without sending excel through links, instead just somehow identifying an open page form and then inserting data from excel table)įor confidentiality reasons I can't share the site's name but here's the right side of the url if it's of any help: Automatically fill out forms with Chrome on Android. What I want to do is say open Product 1 form, have excel sheet 1 data specifically for this product, and then somehow automate it to populate the fields. This time I have around 30 products that have about 30-40 fields each so it takes a hell of a lot of time. Afer doing so, you should be able fill out a web form using vba and chrome as originally requested.I have to fill out a web form using google chrome for many products that have many fields each. Additionally, if you're using Chrome you'll want to update the web driver for Google Chrome here.Īfter downloading these items you'll then need to follow the instructions above for adding the library to in your Visual Basic Editor from within Excel. Set selDriver = CreateObject("Selenium.WebDriver")Īs of 2016, the Selenium wrapper was moved to Github instead of the above Google address. Here is a simple example from the link above (modified to use late binding) that fills out the search field in Google and clicks the search button: Dim selDriver As Object In my (very) limited tests, the only noticeable difference is the couple seconds it takes to load the driver. Once it is installed, either add a reference to Selenium Type Library or use late binding (example below). You can use this Selenium wrapper to drive Chrome or Firefox (or PhantomJS). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |