Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading data from .xls file
Hi,
My boss "ask" me to prepare so called application, which will be able to create report about certain data. Some people are working on their files /.xls/ which consist of lots of data, but I only need to get from those files only certain data /e.g. name of customer, date, number of order, quantity/. I don't want to open their files /using vba/ to copy data because it's too long /and I don't know when my cooworkers are using their files/. The question is - is there any method to read /retrieve/ data from that files without openning them on my computer ? thank in advance for any help or advice, Robert Tomaszewski __________ Informacja programu ESET NOD32 Antivirus, wersja bazy sygnatur wirusow 4928 (20100309) __________ Wiadomosc zostala sprawdzona przez program ESET NOD32 Antivirus. http://www.eset.pl lub http://www.eset.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading data from .xls file
Hi Robert,
I would look into using MS Access and link to the other users files - you would be able to query the data in their files and extract the data you want. If that is not an option, look into using Excel database queries - under the data menu selection, Select Import External Data, New Database Query to acces external data. Blair "Robert T." wrote: Hi, My boss "ask" me to prepare so called application, which will be able to create report about certain data. Some people are working on their files /.xls/ which consist of lots of data, but I only need to get from those files only certain data /e.g. name of customer, date, number of order, quantity/. I don't want to open their files /using vba/ to copy data because it's too long /and I don't know when my cooworkers are using their files/. The question is - is there any method to read /retrieve/ data from that files without openning them on my computer ? thank in advance for any help or advice, Robert Tomaszewski __________ Informacja programu ESET NOD32 Antivirus, wersja bazy sygnatur wirusow 4928 (20100309) __________ Wiadomosc zostala sprawdzona przez program ESET NOD32 Antivirus. http://www.eset.pl lub http://www.eset.com . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading data from CSV file | Excel Programming | |||
Reading data from an excel file to access and vice versa | Excel Programming | |||
reading txt file and copying the lines in new excel file | Excel Programming | |||
reading data from 2nd file in 1st file using Combobox | Excel Programming | |||
reading a data file | Excel Programming |