I am trying to open an Excel workbook that contains macros
from Access97 VB. I use the coding:

Set MyExcel = CreateObject("Excel.Application")
With MyExcel
.Workbooks.Open pathname & "Book1.xls"

to open the file, but I keep getting an error that the
method is invalid. Does anyone know how to open an Excel
file that contains macros using VB and be able to enable
the macros and use them? Thanks!!

Brian ,

I ran your code, albeit in Excel creating a new instance of Excel, and as
long as I defined a value for pathname it worked fine. That should be the
same as for Access VBA I think you might need to post more code to see the
problem.

This is my code, with a line to run a macro in that workbook.

Dim my As Object
Dim pathname As String

pathname = "C:\myTest\"
Set myExcel = CreateObject("Excel.Application")
With myExcel
.Workbooks.Open pathname & "myFile.xls"
End With
myExcel.Visible = True
myExcel.Run ("test")


--

HTH

Bob Phillips

"Brian Walters" wrote in message
...
I am trying to open an Excel workbook that contains macros
from Access97 VB. I use the coding:

Set MyExcel = CreateObject("Excel.Application")
With MyExcel
.Workbooks.Open pathname & "Book1.xls"

to open the file, but I keep getting an error that the
method is invalid. Does anyone know how to open an Excel
file that contains macros using VB and be able to enable
the macros and use them? Thanks!!