Running Excel module within Access

[Id10 Terror]

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

 

[Dave Patrick]

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

:
| 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
|
|