Is it possible to automatically fill a cell with a value (number) from a website? Can it be done without a macro?
Is it possible to automatically fill a cell with a value (number) from a website? Can it be done without a macro?

This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
You can copy data from a web site using "Web Query" (Available under Data>Import external data)
Check the Excel help file for "Web Query" to see if it meets your requirements.
Looks like it will work. I'll need to play with it, but this is exactly what I meant, thx.