Launch Excel from Access macro 1

[ETID]

I got a brain lock....does anyone know the command line, and switches (if any),to start a particular XLS from an Access macro?

 

[logius]

Not sure, but I think it's something like this:

    DDEInitiate "Excel", "C:\My Documents\MyFile.xls"

 

[Databaseguy]

Dim objExcel As Object
Set objExcel = New Excel.Application
With objExcel
'Open the file
.Workbooks.Open FileName:="Your File Name Here"
'Make it visible
.Visible = True
End With
'code here...
Set objExcel = nothing
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[ETID]

Thanks DBguy:

That did the trick.....


and thx to logius, i haven't had time to try your approach yet, but it may come in handy.

:-D