Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intimate the # of records being imported
Upon importing data from a txt file can the user be intimated of the number
of rows/records existing in such a file so as o determine the time and # of rows available in the sheet? -- Best Regards, Faraz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intimate the # of records being imported
Yo can open a text file in a macro and read one line at a time into the
worksheet. You can also read through the entire file to find the number of lines.. then return to the beginning of the file and read the file into the worksheet. Opentext method is just an easy was of reading a text file but doesn't have all the options you require. there are a number of methods that can be used such as OpenTextfile Method, Open file, and Getfile are a few methods. "Faraz A. Qureshi" wrote: Upon importing data from a txt file can the user be intimated of the number of rows/records existing in such a file so as o determine the time and # of rows available in the sheet? -- Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
current date it should intimate cheques due by colour change | Excel Discussion (Misc queries) | |||
Using vb to paste records from 1 sheet, to related records in another | Excel Programming | |||
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet | Excel Programming | |||
draw 999 x 8 random records from file with 8614 records | Excel Programming |