internet

  1. G

    EXCEL and the Web

    Dears all I´m working on a worksheet that need to be actualized on real time with the US market stock such as Dow Jones. Can Excel search ie the coca cola (KO) ´s stock value and put it into my worksheet? Thanks!!!! Guillermo
  2. L

    Web Query Question

    Hi, So I just started messing around with some web query stuff and it's pretty useful. Is it possible to do the reverse? For example, say I have a web query which pulls forum information, is it possible to do the reverse (with a macro or other) which can paste information from a cell in excel...
  3. K

    Recording Web Navigation with VBA

    I am trying to update information from a webite on a daily basis that I need a username and password for and that I need select a specific date range for. Both of these require that I manually input things in order to get the output I am looking for. Unfortuantly, I don't think excel is...
  4. L

    VBA - open file by submitting internet form

    The company I work for has a lot of intranet sites that require a form to be filled out and then the user hits the submit button which then opens a file. Up until now I have been able to use the HTML code to write a line of vba code that opens the file without prompts Workbooks.Open...
  5. I

    Open a secured website using Excel VBA

    I am trying to open a webpage that requests a user id and password, before the page loads. The webpage is on a private network so i can't even show an example i'm afraid. Basically there is a webpage per page server, there are 40. I go to each url, enter the log on details, the page is...
  6. X

    Lists from internet to excel

    Hi, 1. I start from a list on internet, for instance new vocabulary to memorize. 2. I select contents that interest me. 3. I wish to organise that list in necessary columns Doing this manually can be quite painfully boring. Are there other alternatives. Maybe a macro? All helpfull comments...
  7. P

    FTP Files to Web

    After reading the end of chapter 14 in the VBA and Macros for Microsoft Excel I found the article on using Ken Andersons WCL_FTP utility, however I am unable to find a download anywhere on the net to this as pacific internet site does not have it hosted anymore. I also found an update to the...
  8. P

    Running Excel VBA in IE

    I am having trouble running Excel VBA code in an excel workbook through Internet Explorer (IE). The code I have runs fine in Excel. But when I running by opening in IE I get an error. For example trying to run the simple command Range("A1").Select Results in the error message Method 'Range' of...
  9. C

    Automatically display image from URL?

    Hi, I am creating a spreadsheet with various statistics for all the different banner ads that we use. One of the fields in the spreadsheet contains the URL for the actual banner image. Is there a way of making excel automatically display the picture that the URL refers to? Ideally I'd...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top