Results 1 to 2 of 2

Thread: Consolidating Excel files

  1. Nov 30th, 2005, 07:08 PM #1
    skins
    skins is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2001
    Location
    Phoenix
    Posts
    16

    Consolidating Excel files

    hello,
    I've got a project at work and I have to query some information from a number of excel files. They are the exact same format, so I was thinking that rather than querying each of them (via query analyzer), I would like to consolidate them all into one large spreadsheet.
    Does anyone know of an easy way to do this?
    Thanks for the help!
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2005, 06:03 AM #2
    cssriraman
    cssriraman is offline
    Frenzied Member cssriraman's Avatar
    Join Date
    Jun 2005
    Posts
    1,465

    Re: Consolidating Excel files

    Hi,

    First you try to automate one excel file using vba code. After that, you can process all other files.

    CS.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width