web form

  1. N

    VBA Web Form Scraping - Blank field

    Hi everyone, I'm using VBA to populate a web form and 99% of it is working just fine. I have one problem, though, when trying to populate a field that depends on a previous one. This is an internal (corporate) web form so I can't use a real example, but here is an exercise: Imagine I want to...
  2. M

    Excel VBA to Click Ajax Link:

    I am working on writing some VBA code to automate filling out a ticket web form. The piece of this I am currently stuck on is the clicking of a dynamic (search result driven) A HREF tag link that contains what I believe is some AJAX code. On the web form, you enter an asset number into a...
  3. Q

    Automating an excel list to a web form repeatedly

    Hi, I'm completely new to Vba, just starting playing around with it this week. My job is heavy with data entry and I'm trying to be a little more efficient. I have contact lists that live on excel spreadsheets that need to be transferred to web form and the only way of doing it is one at a time...
  4. A

    VBA to fill web forms

    Hello guys, I’m trying to fill a web form for filling multiple boxes trough vba, the website works this way... You input a ticket number, the website redirects you to the main HUB and from there you gotta fill 40 boxes, but the problem is that every time that I enter a new ticket number the...
  5. A

    Strange formatting issue - Help Needed.

    Hi Experts I have a very strage issue. I have sheet with muptiple addresses. When i copy and paste the addresses from excel to a website form It doubles the value. For example. The address is : <tbody> 18 Cheswick Way, Solihull, B90 4JA </tbody> But Pasting it to website form made it...
  6. D

    Read Data from Web Form to Excel Sheet Using VBA

    Hi Everyone, I am new to VBA and I need to fetch values from following form into excel sheet.https://www.moneygram.com/wps/portal/moneygramonline/home/estimator?LC=en-US Once the user clicks on estimate, the exchange rate is displayed. The excel sheet has column headings as the field names in...
  7. B

    Navigating to Website and entering Form Information

    I have read a few other forums on this, but can't seem to find an answer that is effective. I am running Excel 2007 with XP/IE8 and want to do the following. - Go to a form in IE - Pull information from one record in excel and populate the form with that information. - Then move to the...
  8. A

    Excel to web form

    HELP. I am a purchaser who uses amazon to buy materials for conferences. We create a list in excel and then manually transfer that information for each individual person attending any given event. The only thing that would need to get inputted would be the persons name and address. Is there a...
  9. D

    Macro to select Accept in Web form

    Good Afternoon, I have made a macro that opens and copies the below web address below into Excel. However I have hit a problem in that you need to tick accept on the two boxes and then select accept down at the bottom of the page before the correct data is uploaded and the data can be copied...
  10. D

    Royal Mail

    Hi first post so bear with me, I have an amazon small business - no more than 10 orders/day at best. I have a spreadsheet into which I import order reports and use VBA macros regularly to make life easy for myself. One time consuming task is typing the addresses of customers into Royal mail's...
  11. B

    Macro to Search multiple websites and return data

    Hi all, I am new to the forum so please stay with me on this one. I may just need to be pointed to another thread that has addressed this issue already. I would like to develop a Macro that does the following: Collects person's name and address in a form field in Excel, then uses the...
  12. B

    Convert Excel 2007 workbook to web app

    Hello- I have a client who is developing an ROI calculator in Excel 2007. They would like to consider converting the workbook to a web app eventually. Questions... 1. Is there a way to do this within Excel 2007 natively? 2. Are there any "best-of-breed" tools that can be purchased for this...
  13. L

    Need Help with Downloading

    Hi - I'm trying to find out if it is possible to run a calculation on a Web site form, then download it to an excel sheet. Most banks offer this in the financial area of your online checking account. I want to design the same type of set up, but have it related to a different topic. Any...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top