external file data  
Author Message
Nrupesh





PostPosted: Visual Basic for Applications (VBA), external file data Top

HI!

I have got 2 excel files

Eg
Data.xls and report.xls

I need to generate report from data.xls into Report.xls

is it possible that I run a macro look into "A CLOSED EXCEL FILE" and feed that data into another excel file.

Hope I am clear

Cheers
Nrupesh




Microsoft ISV Community Center Forums3  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), external file data Top

Hey man,

These two articles should help....

http://support.microsoft.com/kb/257819/EN-US/

http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tips0607.mspx