Excel to Excel data transfer??Urgent

Hi,
This is my situation:
I have a report that is generated as Excel.The data for this report needs to
come from 2 sources
1.Database
2.Another Excel.
I was able to do the first i.e from the database.
How can I pull out data from another excel into this?
is there any reference material avaible for this.
Any help is appreciated.
Thanks,
SudhaHints: VBA ADO w/in Excel, not too difficult even for a novice. It's kinda like
winForms. When you get stuck, record a maco in Excel, then crack it open in VBA
and it will most likely lead you to many solutions.
If you want a user to initiate the Excel gathered data, then you can add a form
as a dialog and/or command button and/or options.
If you want it to be automated you can initiate on open, further you can even
write methods to pump that data into a subsequent Excel template for final
results were the data is formatted and no longer dynamic as a report should be.
HTH
JeffP....
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:A9154CC8-BE03-4363-9B6B-623FCEA35779@.microsoft.com...
> Hi,
> This is my situation:
> I have a report that is generated as Excel.The data for this report needs to
> come from 2 sources
> 1.Database
> 2.Another Excel.
> I was able to do the first i.e from the database.
> How can I pull out data from another excel into this?
> is there any reference material avaible for this.
> Any help is appreciated.
> Thanks,
> Sudha|||Hi,
Thanks for the reply.But I have to access Input Excel as a part of my report
generation so that the final report gets data from 2 sources database & Excel.
To Clarify further,How can I use Excel as my Datasource for my Report.
How should I do that?
Thanks,
Sudha
"JDP@.Work" wrote:
> Hints: VBA ADO w/in Excel, not too difficult even for a novice. It's kinda like
> winForms. When you get stuck, record a maco in Excel, then crack it open in VBA
> and it will most likely lead you to many solutions.
> If you want a user to initiate the Excel gathered data, then you can add a form
> as a dialog and/or command button and/or options.
> If you want it to be automated you can initiate on open, further you can even
> write methods to pump that data into a subsequent Excel template for final
> results were the data is formatted and no longer dynamic as a report should be.
> HTH
> JeffP....
> "Sudha" <Sudha@.discussions.microsoft.com> wrote in message
> news:A9154CC8-BE03-4363-9B6B-623FCEA35779@.microsoft.com...
> > Hi,
> >
> > This is my situation:
> >
> > I have a report that is generated as Excel.The data for this report needs to
> > come from 2 sources
> > 1.Database
> > 2.Another Excel.
> > I was able to do the first i.e from the database.
> > How can I pull out data from another excel into this?
> > is there any reference material avaible for this.
> >
> > Any help is appreciated.
> >
> > Thanks,
> > Sudha
>
>