EViews.com

Hi All,

I am trying to update my old eviews 6 programs and found out that the import function is not as easy as I thought it would be. Say if I am importing several sheets from the same Excel 2007 file using a loop (same data format in each of these sheets), and the top leftmost numeric value of these sheets all start in the cell B6, how should I specify the import function?

So far, I have: where %file_loc is the location of the file, and the %tab_current is the current tab name. I wonder how I can make it read only from B5 (variable names)? Please let me know. Thanks.

Tchaithonov

something similiar to
will work

Further to Jason's response, since the "range" argument is expecting something enclosed in quotes, you probably don't want to put braces around your %tab_current variable, since putting braces around a string variable effectively removes the quotes.

You should also take a look at the program in the last post of this thread, since it does something pretty similar to what you are doing.