website

  1. S

    Automated Excel Report to Web

    Hi all, I'm trying to weigh my options for generating reports to be displayed on a website. I currently have an Excel workbook that imports data from a database, based on user input, and creates a report on a worksheet. The report includes a combination of text and charts. The process to create...
  2. Z

    Relative referencing Excel VBA command buttons.

    I have several user names and passwords, which I need to enter on one website. I have saved those user name and passwords (one record per row) in an excel 2007 macro enabled file. I have found out how to open and fill in the fields of that website and click the submit button with the help...
  3. D

    Opening Website in Different Browsers using Macro

    Hi All, I would like to ask your help to resolve my query. Is it possible to open the websites in different browsers using macro code? Example: I have the heading as MrExcel.com and three buttons named as below: First Button: Open Website Using Internet Explorer Second Button: Open Website...
  4. T

    How to get all links and sublinks from a website

    I want to step through all links and sublinks in a website to get information from some of the pages. The pages are in 7 levels, so I use nestled For. I am able to get the first link on the top level page. I also can navigate to that link and sublinks. But when a For loop is done I don't get...
  5. S

    Integrating a Excel VBA Program into a website

    Hi There, I was wondering whether it is possible to integrate my program into an existing website so multiple people can access it online. Its a time & expenses program that is currently on a cloud system, which unfortunately allows multiple edits, and then end up with multiple versions. Any...
  6. W

    Excel cell info passed to Website as input - Code provided

    Hi All! I’m not quite new to VB code but I haven’t touched it in 10 years and that was just a class in high school so I’m starting over from scratch. I’ve hit a bit of a bump with this little project I’m working on and was hoping you all could assist or point me in the right direction. First let...
  7. K

    Extract / scraping DIV data from website and copy to Excel

    Hi, Here is the challenge. In the past, elements were more or less fixed and was able to use my very well known method QueryTables under Workbooks.open This website below has a "div", called "div.sidemeta" wihick contains the information I want to grab...
  8. A

    Using VBA to login and pull file from website

    Hello everyone, i'm getting a little stuck and hoping someone can help redirect me. Scenario: I process commission statements and for one client we get 30 different login's for each one of our producers. I currently have all the logins and passwords in an excel document. I must login to each...
  9. D

    Web Scraping from list of locations

    Let's start by saying that I've never done webscraping. It seems like it should be a fairly easy process, but I need to pull data from multiple websites. The url for my first location is...
  10. B

    Link to a website using a value in a column

    Hi Pros, Using Excel 2010. I want to hot link to a server using a value in column A. For example: A..........b.........c................. 2014......joe......tom 2022......bill.......mary 2061......bob......joe I want to have a Macro button that will link to a web site, using a value (ie...
  11. M

    Navegating through a website

    Hello everyone! I'm fairly new to Excel and VBA altogether and i got some doubts about VBA. Right now, i have a worksheet with several cells filled in with info. What i want to do is go to a website and search for a few strings on the page and if i find them i want to click on the link...
  12. J

    Excel chart to HTML to website

    I am running a system that uploads data periodically to an excel chart. I want to publish this chart onto a website and have it automatically be updated to the website at the same rate that the data is updated in the excel file. I have started by using this VBA macro: <o:p></o:p> <o:p>Sub...
  13. R

    .Document.forms(0).Item("name").Value = Copied Value?

    What can I put after the "=" in the above code to make that value = a cell that has been copied from excel? Preceding that code is: Range("B3").Select Application.CutCopyMode = False Selection.Copy Now I would like vba to paste that value into a webpage. I can state the specific...
  14. D

    VBA Parsing the webpage for a specific value between tags

    Hi all, I am trying to extract a specific value from a static webpage. so far I come up with the following script: Sub Macro1() my_url = "http://www.investopedia.com/search/default.aspx?q=rog" Set my_obj = CreateObject("MSXML2.XMLHTTP") my_obj.Open "GET", my_url, False my_obj.send my_var =...
  15. F

    Linking Excel to external mySQL Server for PHP

    I run a football (soccer) website and on it there is quite a bit of data and quite a few statistics such as league tables, goalscorers, appearance totals etc. which can change on a daily basis. Rather than change each page each day, the data is fed in to the website using PHP and MySQL. I...
  16. X

    Using VB in Excel to pull data from certain websites

    Lets say column A1:A100 has FEDEX training numbers. Then is column B2:B100 I have the following address repeated "http://www.fedex.com/Tracking?clienttype=dotcom&ascend_header=1&cntry_code=us&language=english&mi=n&tracknumbers=" So in cell C1 I do a concatenate(B1,A1) to make a whole tracking...
  17. E

    In VBA after automated xml form post, how can I automate interaction with the response?

    I am using xml in VBA. The code below adds an item to a shopping cart on a remote website (posts a form). Then the code displays the result in Internet Explorer. You can see in the response there is a "get estimates" button. I need to automatically click that, enter location info, and get the...

Some videos you may like

This Week's Hot Topics

Top