internet

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

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...

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...

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...

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...

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...

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...

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...

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...