[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Michael Blasnik" <michael.blasnik@verizon.net> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
Re: RE: st: Appending several excel data sets into one |

Date |
Mon, 17 Sep 2007 10:26:40 -0400 |

I agree that the suggestion to purchase some separate product to alter the xls files when the same task can be easily automated in Excel is silly, but it's also silly to try to write VBA code in Excel and launch it through a Stata do file when everything can be done within Stata directly. The Excel VBA route would certainly make it more difficult to produce documented and reproducible results, especially if you want to be able to send your do file to someone else and have them reproduce it.

Michael Blasnik

----- Original Message ----- From: "Sergiy Radyakin" <serjradyakin@gmail.com>

To: <statalist@hsphsun2.harvard.edu>

Sent: Monday, September 17, 2007 10:14 AM

Subject: Re: RE: st: Appending several excel data sets into one

Here is a quote from Mr. Coveney "If workbooks contain multiple sheets, you would like to access the sheet names. Excel doesn't provide this facility, but an add-in called ASAP-utilities http://www.asap-utilities.com/ includes one to create an index sheet listing all sheets in the workbook. " And this is exactly where my comment was pointed to (index sheet). Otherwise I would have posted a VBA code that appends 200 sheets together. The quoted utilities package actually retails for $49! What a deal! (after having a look at what the utilities actually do, e.g. "Displays the filename in the titlebar" or "Close all saved files" I think that the code of each of those utilities is no longer than 5-10 lines). If we go the "external way", why don't we just buy software to append Excel sheets? Just google it and take the first best (in my case Google came up with http://www.office-excel.com/excel-addins/tables-transformer.html for 39$, which claims to be able to append Excel sheets. I honestly have no clue on what it does and how it does it, but it looks more adequate than the utilities suggested above.) The second-best DigDB provides a price comparison of the similar tools, which might be useful for other users: http://www.digdb.com/purchase/ but I feel a pain to pay $50 for 10 lines of code (feels like having to buy .ado files -- something unheard of). It might take 5 more minutes to find a ready snippet on the web. As for reproducibility of the results, you can execute VBA code from the same Stata do file. I do not see a problem here (it does not look elegant, though). Best regards, Sergiy Radyakin

* * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**References**:**Re: RE: st: Appending several excel data sets into one***From:*Joseph Coveney <jcoveney@bigplanet.com>

**Re: RE: st: Appending several excel data sets into one***From:*"Sergiy Radyakin" <serjradyakin@gmail.com>

**Re: RE: st: Appending several excel data sets into one***From:*"Michael Blasnik" <michael.blasnik@verizon.net>

**Re: RE: st: Appending several excel data sets into one***From:*"Sergiy Radyakin" <serjradyakin@gmail.com>

- Prev by Date:
**Re: RE: st: Appending several excel data sets into one** - Next by Date:
**Re: RE: st: Appending several excel data sets into one** - Previous by thread:
**Re: RE: st: Appending several excel data sets into one** - Next by thread:
**Re: RE: st: Appending several excel data sets into one** - Index(es):

© Copyright 1996–2015 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |