Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
advise on how to import data into excel sheet
Appreciate any help of advise on the following:
I am using a scheduler called z-cron to start safari web browser which has its start up ie its home page connecting via port to another running application to collect data from this application ( I can only collect the applications data using web client ie cannot export it ...). This captured text data now in the web browser is then cut and paste into xcel sheet manually ( appending to the bottom of an open sheet ) Appreciate advise on how to I can use xcel to do the cut and paste automatically for me. Thanks for any help Sam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
advise on how to import data into excel sheet
On May 4, 2:25*pm, "sammy" wrote:
Appreciate any help of advise on the following: I am using a scheduler called z-cron to start safari web browser which has its start up ie its home page connecting via port to another running application to collect data from this *application *( I can only collect the applications data using web client *ie cannot export it ...). This captured text data now in the web browser is then cut and paste into xcel sheet manually ( appending to the bottom of an open sheet ) Appreciate advise on how to I can use xcel to do the cut and paste automatically for me. Thanks for any help Sam EXCEL 2007 1. Open an EXCEL file (the one I used was the following):- C:\excel\import_data_using_a_web_query.xlsx 2. Data tab. Get External Data group. Click:- From Web The New Web Query window should open. 3. In the:- Address: - field type in the address that you want to import; for example:- http://webfund6.financialexpress.net.../Ourfunds.aspx Click:- Go (At this point you can filter the data that you import by clicking on the black arrows, on a yellow background, on the left hand side). Click:- Import The Import Data window should now open. 4. Click in cell A1 (for example) then click:- OK The data will now be imported into the Workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data from previous sheet in excel | Excel Discussion (Misc queries) | |||
Import data into Excel sheet from CSV File | Excel Discussion (Misc queries) | |||
Best way to import data from an e-mail to an excel sheet? | Excel Discussion (Misc queries) | |||
Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I import data from 1 workbook excel sheet into another? | New Users to Excel |