How to change the path when using VBA macro to run .m file
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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
0 comentarios
Respuestas (2)
Kaustubha Govind
el 19 de Jul. de 2011
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.
0 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!