Calling EViews from excel with spaces in the path name

[djackson]

I'm trying to run an eviews program from Excel, but if there are spaces in the path name then it truncates the path at the first space. How do I get around this? Code I'm using is below.

Code: Select all

Dim mgr As New EViews.Manager
Dim app As EViews.Application
Dim program_to_call As String

prog_path = "C:\EV_Auto_test\Space test\interpolate_q"

Set app = mgr.GetApplication(ExistingOrNew)
app.Run "run " & prog_path


[EViews Steve]

Put quotes around the path inside your string.

Like this:

Code: Select all

app.Run "run """ & prog_path & """"

Steve

[djackson]

Thanks very much, I knew it would be something simple I was missing.