Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 05, 12:23 AM
DavidMunday
 
Posts: n/a
Default Using other workbooks..


I have a set of xls files that contain data I would like to import into
another xls sheet, however the file that I need to import from will
depend on a date entered into a cell in the destination file. The
source files are named with the following convention:

Week of 3-22-04.xls

I would like to be able to pull data from a worksheet in that
particular file by putting the date 3/22/04 into my main spreadsheet.

Thanks,
David


--
DavidMunday

  #2   Report Post  
Old June 28th 05, 08:31 AM
Alex
 
Posts: n/a
Default

David

I don't think that what you want to do is possible with straight forward
Excel functions.

I have wriiten some code that will do what you want but is written in VBA
(not sure if you are familiar with this).

Before I post it, would let me know whether you are happy to receive a VBA
based solution. If you are unfamilier with it then there maybe little point
in sending it.

To paraphrase, I have written some code that will enable you to type the
date of the file you wnat into cell A1 of a spreadsheet. Then you press a
button and it will draw in the data you want from that excel file. All this
opertaes without you having to open the excel sheet you wnat the data from.

You would have to amend the code to set the correct filepath for your files
as well as the Excel data range that you wnat to import. Obviously I do not
know those things.

Let me know if you are interested...

Alex

"DavidMunday" wrote:


I have a set of xls files that contain data I would like to import into
another xls sheet, however the file that I need to import from will
depend on a date entered into a cell in the destination file. The
source files are named with the following convention:

Week of 3-22-04.xls

I would like to be able to pull data from a worksheet in that
particular file by putting the date 3/22/04 into my main spreadsheet.

Thanks,
David


--
DavidMunday



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate different sheets to different workbooks markx Excel Worksheet Functions 3 April 26th 05 03:30 PM
linking to multiple workbooks cwwolfdog Excel Discussion (Misc queries) 4 April 18th 05 05:29 PM
Links between workbooks Eddie Excel Discussion (Misc queries) 0 April 18th 05 03:21 PM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 08:27 PM
Workbooks...I'll try this again... Markster Excel Discussion (Misc queries) 10 December 7th 04 10:12 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017