How to change the path when using VBA macro to run .m file

Hi,

I'm trying to write VBA macros to run m file on a desired folder while calling Matlab.

The folder path located the m file is "C:\Documents and Settings\M02043\Desktop\Test".

However, I always get a default path, "C:\Program Files\MATLAB\R2008b", so I can't run the m file from this.

Do you have any idea how I can set the path I wanted when using VBA macro to run .m file.

Matlab version: R2008b (7.70)

VBA macors:

Sub Macro()
Dim MatLab As Object
Dim Result As String
Set MatLab = CreateObject("MatLab.desktop.Application")

Call MatLab.Execute("cd C:\Documents and Settings\M02043\Desktop\Test")
Result = MatLab.Execute("f_ann")
End Sub

Answer 1

[Kaustubha Govind]

You need:

   Call MatLab.Execute("cd 'C:\Documents and Settings\M02043\Desktop\Test'")

The CD command doesn't like spaces in the directory path - you need single quotes around it.

Answer 2

[Surae]

I solved this issue with following macros. The problem was just CD command :)

Sub Macro()
Dim MatLab As Object
Dim Result As String
Set MatLab = CreateObject("MatLab.desktop.Application")

Result = MatLab.Execute("cd('C:\Documents and Settings\M02043\Desktop\MATLAB Interface Test')")
Result = MatLab.Execute("f_ann")
End Sub

thanks a lot.