Here is a tip which may help you when importing text files into Excel. If you frequently import comma delimited files into Excel, you might not realize that you can open the text file, read each line directly, then close the file, as shown here:

Sub ReadTextFile()
'Open text file for reading
Open "Data.prn" For Input As #1
'Process each line in file, until end of file is reached
Do While Not EOF(1)
'Read first record of a line
Input #1, Rec1
'Determine if blank line
If Rec1 = Empty Then
'Blank line - do nothing
Else
'Otherwise, read remaining records on line
Input #1, Rec2, Rec3, Rec4, Rec5, Rec6
'Write records to the Debug window
Debug.Print Rec1, Rec2, Rec3, Rec4, Rec5, Rec6
End If
Loop
'Close text file
Close #1
End Sub

The alternative is to open the CSV file as a workbook, select the active area, copy it to the clipboard, then paste it into where you need it. (We'll soon modify this to write the data directly to cells, rather than just to the debug menu).

Check out these tips that relate primarily to Peachtree Accounting, but may be helpful in other instances also.

Importing a Lotus 1-2-3 spreadsheet into Excel can leave you with dozens or hundreds of comments where formulas didn't convert. An easy way to clear all of these comments at once is to use the following routine:

Sub ClearComments()
For Each c In ActiveSheet.Comments
c.Delete
Next
End Sub