Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: How do I import a macro-enabled Excel worksheet into Stata 12?
From
Sergiy Radyakin <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: How do I import a macro-enabled Excel worksheet into Stata 12?
Date
Fri, 28 Jun 2013 20:05:22 -0400
I don't know the answer for sure, but a first step to find it could be
to create a trivial 'light' file with a couple of numbers and a simple
macro, save it and try to import. If it fails on the simplest file -
then it is likely not gonna import your real 'heavy' file. If it does,
then we know that the feature exists, and we could look into how the
'heavy' file differs from the 'light' one.
Best, Sergiy
On Fri, Jun 28, 2013 at 4:25 PM, John Bensin <[email protected]> wrote:
> I have an Excel 2010 worksheet that's saved as a macro-enabled
> worksheet (.xlsm). When I attempt to import it into Stata 12 with this
> command:
>
> import excel "finances.xlsm", sheet("Budget") firstrow clear
>
> it returns an r(603) error of "file finances.xlsm could not be
> loaded". The documentation describes the error with:
>
> "This file, although found, failed to open properly. This
> error is unlikely to occur. You will have to review your
> operating system's manual to determine why it occurred."
>
> Does Stata 12 not support .xlsm files, or is there another problem at
> work here? I use a fully updated Stata 12 on Windows 7 64-bit, with
> Excel 2010.
>
> John
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/