Running Excel module within Access
 

Hi:

I have both MS Excel 2003 and Access 2003. I am getting an Excel module
that will connect to the internet and download some information. I will
only use Excel for this single feature. I always work within Access and now
I need to know how to run that Excel module within Access so that I can
import/link and append the records.

Can any show me how to run an Excel module within Access?


Thanks

Running Excel module within Access
 

This may give you some ideas.

Function Open_Test()
Dim xlApp As Variant
Dim xlBook As Variant
Set xlApp = CreateObject("Excel.Applicatio*n")
Set xlBook = xlApp.Workbooks.Open("C:\data\*excel\Test.xlt")
xlApp.Run "testproc"
xlBook.Close (False)
xlApp.Quit
Set xlApp = Nothing
Set xlBook = Nothing
End Function

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Id10 Terror" wrote:
| Hi:
|
| I have both MS Excel 2003 and Access 2003. I am getting an Excel module
| that will connect to the internet and download some information. I will
| only use Excel for this single feature. I always work within Access and
now
| I need to know how to run that Excel module within Access so that I can
| import/link and append the records.
|
| Can any show me how to run an Excel module within Access?
|
|
| Thanks
|
|