| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to determine the length of a .prn file.
One of my VBA macros opens and then imports a .prn or .txt file into
an excel workbook. Sometimes the number of records in the file exceed the maximum rows permitted by a single Excel worksheet. How can I test for the number of rows in the file before opening, parsing and copying it into my workbook? If it exceeds say 65500 rows I'd like to pop up a message and then exit the Sub. TIA Richard Buttrey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging values down a range using a colum to determine its length | Excel Worksheet Functions | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| Calculate Months to Determine Length of Service | Excel Worksheet Functions | |||
| How to determine the arc length in Excel? | Excel Discussion (Misc queries) | |||
| Determine maximum length of a page | Excel Programming | |||
![Richard Buttrey[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
