Open a file and start macro from macro in another file

[Fryer Tuck]

I am trying to have a macro in a particular file open another file and have it start a macro in that file. I can get it to open the file, but not get the macro to start. I have used RunAutoMacros w/ xlAutoOpen, but I either get errors or no macro running after the file opens.

[Ivan F Moala]

On 2002-03-21 21:17, Fryer Tuck wrote:
I am trying to have a macro in a particular file open another file and have it start a macro in that file. I can get it to open the file, but not get the macro to start. I have used RunAutoMacros w/ xlAutoOpen, but I either get errors or no macro running after the file opens.

Try [untested]

Application.Run "'Theworkbook.xls'!MacroName"


Ivan

[Fryer Tuck]

Still getting error 438:
Object doesn't support this property or method.
Any other ideas

[Ivan F Moala]

On 2002-03-21 23:02, Fryer Tuck wrote:
Still getting error 438:
Object doesn't support this property or method.
Any other ideas

What code are you using ?

[Fryer Tuck]

Using VBA in Excel 2000
In response to a command button on a form, the following code is executed:

Workbooks.Open (FileName:=Path and file, Password:= password to open).Activate

Application.Run "'workbook.xls'!macro"

I tried this with "RunAutoMacos xlAutoOpen" in place of the "Activate", but still didn't get anywhere.

[Ivan F Moala]

On 2002-03-21 23:47, Fryer Tuck wrote:
Using VBA in Excel 2000
In response to a command button on a form, the following code is executed:

Workbooks.Open (FileName:=Path and file, Password:= password to open).Activate

Application.Run "'workbook.xls'!macro"

I tried this with "RunAutoMacos xlAutoOpen" in place of the "Activate", but still didn't get anywhere.

This worked for me;

Private Sub CommandButton1_Click()
Workbooks.Open Filename:="C:ExcelFilesUsefulVBA Get GUID.xls", password:="test"
Application.Run "'VBA Get GUID.xls'!MoreReferenceWork"
End Sub


Ivan

check your coding ??

[Fryer Tuck]

Could there be some switch in Excel that is blocking this? I am still getting the Run-time error 438"Object doesn't support this property or method"

[Dave Hawley]

Hi Fryer


If you are using the Auto_open (check out Workbook_open) you will need the "RunAutoMacros" Method

Workbooks.Open (FileName:=Path and file, Password:= password to open)
ActiveWorkbook.RunAutoMacros