Re: [EnergyPlus_Support] Excel 256 Column Limit Solution

["Michael J. Witte" <mjwitte@xxxxxxxx>]

Thanks!  If someone would like to code this up and perhaps modify it to include 
the date/time stamp column on each tab, we could share it through the yahoo 
group files area.

Mike


On 2 Nov 2006 at 17:49, noelcrrl wrote:

> Dear All,
> 
> I have found a macro that is compatible with Excel.  It splits the 
> data (greater than 256 columns, limit 510) from the E+ CSV file into 
> multiple sheets in Excel with ease.  The link to the Macro is the 
> following: 
> 
> http://support.microsoft.com/?kbid=272729 
> 
> Hope this helps!
> 
> Noel Corral
> 
> 
> 
> 
> The primary EnergyPlus web site is found at:
> http://www.energyplus.gov
> 
> The group web site is:
> http://groups.yahoo.com/group/EnergyPlus_Support/
> 
> Attachments are not allowed -- please post any files to the appropriate folder
> in the Files area of the Support Web Site.
> 
> EnergyPlus Documentation is searchable.  Open EPlusMainMenu.idf and press the
> "search" button.
>  
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 


========================================================
Michael J. Witte, GARD Analytics, Inc.
EnergyPlus Testing and Support      
EnergyPlus-Support@xxxxxxxx





The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are not allowed -- please post any files to the appropriate folder in the Files area of the Support Web Site.

EnergyPlus Documentation is searchable.  Open EPlusMainMenu.idf and press the "search" button.
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:EnergyPlus_Support-digest@xxxxxxxxxxxxxxx 
    mailto:EnergyPlus_Support-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    EnergyPlus_Support-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/