[Limdep Nlogit List] Trouble with Excel 2007

[Con Menictas]

Dear All,

There is a "Compatability Pack" that Microsoft offers on its website for those that load 2007 which comes as a free patch enabling cross version compatability. If you do not install these updates you will encounter issues opening previous versions of Microsoft Office and visa versa.

regards,

Con.

----- Original Message -----
From: Jill Caviglia-Harris <jlcaviglia-harris at salisbury.edu>
Date: Monday, September 29, 2008 7:56 am
Subject: Re: [Limdep Nlogit List] Trouble with Excel 2007
To: limdep at limdep.itls.usyd.edu.au


> Thanks.
> 
> Jill Caviglia-Harris
> Associate Professor
> Economics and Finance Department
> Salisbury University
> Salisbury, MD 21801
> (410) 548-5591
> >>> Mikołaj Czajkowski <miq at wne.uw.edu.pl> 09/28/08 5:13 PM >>>
> Jill Caviglia-Harris wrote:
> > List Serve Subscribers:
> > 
> > I am having a significant amount of trouble reading files that have
> been created in Excel 2007.  Saving as 2003 version does not seem to
> work - yet I can read the files I created in the 2003 version prior to
> switching to Excel 2007.  The other option is to save as a csv file -
> but it is my understanding that the csv read requires that you enter in
> the variables names by hand - this is not useful as the data I am
> reading changes often (names of variables and order in which they are
> included).  I have tried the names=n and labels=1 commands but cannot
> seem to be able to read in the variable names from the csv version.
> 
> Dear Jill,
> 
> This seems to be a known issue due to changes in file structure Excel 
> 
> 2007 introduced. Even if you save a file as Excel 2003 in Excel 2007 
> it 
> would not work. In practice I send the excel file to a machine with 
> any 
> office prior to 2007 just to open the file and save it. Alternatively 
> 
> you might go through .txt format, it looses variable names as you have 
> 
> noticed.
> 
> Best regards,
> 
> -- 
>      Mikołaj Czajkowski
> 
>      Warsaw Ecological Economics Center
>      Warsaw University
>      http://www.woee.pl/
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au
> 
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au

-- 
UTS CRICOS Provider Code:  00099F
DISCLAIMER: This email message and any accompanying attachments may contain
confidential information.  If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments.  If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with authority,
states them to be the views of the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.

Think. Green. Do.

Please consider the environment before printing this email.