Re: Need Help with merging Excel files
Re: Need Help with merging Excel files
- Subject: Re: Need Help with merging Excel files
- From: David Wignall <email@hidden>
- Date: Tue, 10 Sep 2002 22:47:11 +1200
on 10/9/2002 10:22 PM, David Wignall at email@hidden wrote:
>
on 10/9/2002 1:57 PM, Peter Kincaid at email@hidden wrote:
>
>
> Is there any way to merge a folder of Microsoft excel files (with new
>
> additions daily) into 1 file, and then do a find in that new file.
>
>
I think you're after Data -> Consolidate. Easy enough to do through the
>
interface but not difficult to do through code, either VBA or, after a quick
>
look at the dictionary entry, AppleScript.
Sorry, accidental use of cmd-return in Entourage! The snippet I left off is
Range "A1" Consolidate Sources
{"Workbook1.xls!ConsolidationArea","Workbook2.xls!ConsolidationArea"}
Function xlSum with TopRow and LeftColumn -- all one line, tested
where ConsolidationArea is a named range and Workbooks 1 & 2 are in the same
directory as the book I was consolidating onto.
--
hth
Dave
<cmd-return>
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.