EViews.com

Thanks, that did it. I also hard-coded the range= and put double quotes around the tab name. %command = "import " + """" + %curr_path + """" + " range=" + """" + %tab + """" + %half2 Thanks again, Jon...

Thanks for that. The use of recode is something I need to consider more.
Jonathan

Hi, This question is similar to that of the Defining Path thread although the responses there don't seem to be helping. I'm trying to do something like this: %curr_path = "Z:\Forecast_Sales\Results\0815\ABC August 2015 Sales Results.xlsx" . . . %half2 = " byrow colhead=2 namepos=last ...

Okay, I guess looping through a table of paired values is best for a long list. Thanks for the fast reply!
Jonathan

Hi, Is there a clean way to do something like the following: if %mif %m_long="January" then %m_short = "01" else if %m_long="February" then %m_short = "02" else if %m_long="March" then %m_short = "03" . . . endif endif endif That works but ...