There is a function there, which could do it. The function Sendkeys sends your chosen characters to the keyboard buffer. In fact the buffer may take I think up to 300 characters in one hit without overflow. Even then you could use a pause function while the buffer empties. Basically, it would be the fastest data entry system in history.
Sendkeys %26quot;What ever characters you want to kend to the keyboard%26quot;, false
A macro could be written to do something like this automatically
1. Access the correct page on the Net
2. Pick the necessary information off the screen
3. Analyse it
4. When the time is right, and certain conditions are met, enter the information back to the website.
Is it possible for a constantly changing number on a website to be reflected on an Excel spreadsheet?Interesting Q!
So you want to take a reading of a webpage (like temperature) that doesnt support alive feed wrt this particular item.
You'd have to sample it every x seconds. Parse it to get the right value out of the whole blob and store that in an excell format.
You'd have to write specific software for it.
And a little problem: depending on their webserver and protection, they might see it as an attack and block you (temporarily)Is it possible for a constantly changing number on a website to be reflected on an Excel spreadsheet?You'll have to be more specific if you want a better answer, but have you tried using %26quot;smart tags%26quot; and/or queries? Works great for some things (stock prices, DJIA, etc....) but not as well for others (FF scores that require a log in). Hope this helps!Try Data, Import External Data, New Web Query. You supply the address of the page that contains the number. Once you are viewing that page, you'll see markers for the tables on that page that are available for you to import data - click on the marker or markers (in Excel 2003, it looks like an arrow and when you click on it the arrow changes to a check mark). Click the Import button. The entire table (or all tables if you selected more than one) is imported to Excel.
Then, you can make a cell in your sheet equal to the number in the table that was imported if what you want to do is show only that one number somewhere in your workbook.
Once you have your data imported, you can click into it and the Externam Data toolbar should display (if not, turn it on manually). There's a button on the toolbar to open the Data Range Properties and settings there for refreshing the data.
Hope this helps......
