|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
|
| |
|
|
|
East Greenwich,
RI 02818 |
|
| |
|
|
|
401.885.3631 |
|
| |
|
|
|
401.884.5653 Fax |
|
| |
|
|
|
|
|
|
|
|
|
|
|
401.996.3631 Cell |
|
| AMDG |
|
|
|
"Once you
know it, it's Easy!" |
autosoft@aol.com |
|
| Commercial and custom computer related products spanning the
areas of data acquisition and control, simulation and modeling, numerical
analysis, chemical process design and manufacturing management information
systems design. Founded in 1982. |
|
| We know Excel! Whenever possible, Excel
is the user interface, VBA is the programming language, ODBC connects to the
database of your choice. |
|
| Home |
About Us |
Literature |
Wire
& Cable |
Pharmaceutical
& Biotech |
Construction
Management |
Commercial
Products |
Custom Solutions |
|
| Contact Us |
Events |
Downloads |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
![MCj02512670000[1]](big_files/index_0000_image004.gif)
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| For those of us who have not yet upgraded to Excel 2007, we are
still stuck with the 65,536 row limit on a spreadsheet. The BIG File Utility opens a text file,
places the first 65,000 rows in Sheet1 of a new workbook, puts the next
65,000 rows in Sheet2 and so forth until the file has been completely opened. |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Download the BIG File Utility here. |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AutoSoft Systems | 2 Round Hill Court, East
Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 |
Mobile: 401.996.3631 |
|
| This web page was last updated at 04/27/2010 06:57 PM and is
written in EXCEL! |
|
| AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach
- AutoSoft Systems is not affiliated with Consona nor Zumbach |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|