Re: Collate information from different files via a macro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Nav,

See Ron de Bruin's sample code at:

Copy a range from closed workbooks (ADO)
http://www.rondebruin.nl/ado.htm



---
Regards,
Norman


"Nav" <Nav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:009C36FE-2233-440D-BB84-EF26093FB4BE@xxxxxxxxxxxxxxxx
Hello

I have 10 files (1 per person- S:\data\(initials)) they have the same
format
(1st four columns) with data in them with the first row as a header. I
wish
to create 1 file for all this data, is there an easy way to obtain the
data
from all the files and create a new one under S:\data\combined without
having
to open then all 1 by one and copy and insert the cells into the new
combined
file (the data range also changes on a day to day basis).

Please can you provide suggestions, thank you in advance for your help.

Regards.


.

Relevant Pages

  • Fujitsu ADO Data access guidance needed
    ... Could someone please provide some sample code or point me to a good tutorial or reference material regarding the use of ADO to access Microsoft SQL server, ... I think I saw a post here stating that ADO is better. ...
    (comp.lang.cobol)
  • RE: update cells in unopened workbooks
    ... according to Ron you can use ADO to both read and write to closed files. ... "pete the greek" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Cannot read data from Access 2007 database
    ... I'm using ADO to acces the Access database. ... some very simple sample code of mine that attemps to read the "DATE" ... description is always "Unknown error 0x800A0CC1" ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Why dont I use DAO?
    ... Microsoft has stopped supporting DAO and is now pushing ... ADO is simplified a lot by using Mr. Carlos Antollini see his ... If you don't have this file, you can get it by installing Microsoft Office ... The CHM file is full of sample code, and has many useful tips, e.g. the Find ...
    (microsoft.public.vc.mfc)
  • Re: Copy an Excel sheet using VBA
    ... I'm using ADO now but was hoping there was some Excel/VBA quickie way I'd ... worksheet between closed workbooks. ... Is it possible to copy a worksheet from a closed workbook on a computer ... LAN into a running Excel workbook on a different computer on the same LAN ...
    (microsoft.public.excel.programming)