Saved Bookmarks
| 1. |
Solve : Transfering data from internet to excel? |
|
Answer» Hi 1. Is the a way to have a web page and excel spread opened at the same time on the same screen?. 2.I would like to Be ABLE to get information from the web page and post it to the spread sheet while both are opened. I don't know if it can be done. I thought I would ask. Thank You If you have both opened with sized WINDOWS you could potentially have excel using 1/2 the screen and the web browser using the other half. Transfer from ONE to the other you can manually copy/paste info across unless the content is protected from copy/paste or an image form where numbers are actually an image vs ascii. Anything like this for large amounts of DATA, you either would program a keyboard/mouse macro to run through redundant process such as using jitbit Macro recorder or another macro creation software or you can write a C# program for EXAMPLE that parses a website for information and passes that information such as comma delimited to a CSV file to be opened in excel later as a raw data import.If you're using Windows 7, becoming familiar with the Snap feature might be quite helpful to you. It's an easy way to place open two windows side-by-side, with each using half of the monitor screen. For some a video on using Snap, see https://www.bing.com/videos/search?q=using+snap+in+windows+7&view=detail&&mid=18F44DB5E3DC6886D51718F44DB5E3DC6886D517&rvsmid=18F44DB5E3DC6886D51718F44DB5E3DC6886D517&fsscr=0 or do a search on using snap in windows 7 for more. Correction: It's an easy way to place open two windows side-by-side ... Or: It's an easy way to place open two windows side-by-side ... |
|