Quicken Interchange Format (QIF) is an open specification for reading and writing financial data. Use this XL2QIF Excel macro to convert to QIF. The above two paragraphs are based on exporting and importing in Quicken 2010. Jan 13, 2011  Microsoft Excel 2010. The latest version of Microsoft’s popular spreadsheet application boasts a sprinkling of new features. There’s a new free add-in for that, called PivotTable for Excel 2010. Other new features are common to other Office 2010 apps too: Excel replaces the Office button with a new File option on the ribbon: click this.

Hi John, You may have already seen these links but there may well be more than one XL2QIF addin around. I guess it goes to and from QIF. There are a couple of other links as well. In any case these are free not shareware. The XL2QIF that I have the link for indicates Converts bank statement or credit card statement information.

Quicken Interchange File used by Quicken and MS Money (#QIF) Stocks, Quotes and keeping track of Habeeb's (McGyver) does stocks but the link is dead, I found that his free software is on a members only payfor free software site -- I expect that he would not be very happy about someone else making personal gain on what he provided for free. I would avoid such pay for sites on general principle, but it probably not updated and it was a bit of a hassle to have to have Quicken up when the addin was active.

Hi, I have written this little macro. 1) Open the.QIF with text file 2) Copy and paste data into Sheet1 of workbook 3) Split text into column 1 as code column 2 as value 4) run the macro Sub translate() Dim String1, String2 As Variant Dim i, n, EndofDataRow As Integer Dim R As Object Dim Cols As String Dim thisRow As Integer thisRow = 2 Cols = 'A:B' Columns(Cols).Select ActiveWorkbook.Names.Add Name:='Check', RefersToR1C1:='=Sheet2!' & Cols Set R = Range(Cols) EndofDataRow = Selection.SpecialCells(xlLastCell).Row For n = 1 To R.Rows.Count If (Cells(n, 1).Value = ') And _ n > EndofDataRow Then Exit For End If Select Case Cells(n, 1).Value Case '!'

Case ' Case 'D' 'Date Sheet1.Cells(thisRow, 5) = Sheet1.Cells(n, 2) Case 'M' 'Memo Sheet1.Cells(thisRow, 6) = Sheet1.Cells(n, 2) Case 'N' 'Action Sheet1.Cells(thisRow, 7) = Sheet1.Cells(n, 2) Case 'Y' 'Stock Name Sheet1.Cells(thisRow, 8) = Sheet1.Cells(n, 2) Case 'I' 'Price Sheet1.Cells(thisRow, 9) = Sheet1.Cells(n, 2) Case 'Q' 'Quantity Sheet1.Cells(thisRow, 10) = Sheet1.Cells(n, 2) Case 'O' ' Commission Sheet1.Cells(thisRow, 11) = Sheet1.Cells(n, 2) Case 'T' 'Total cost Sheet1.Cells(thisRow, 12) = Sheet1.Cells(n, 2) Case '^' 'Next item thisRow = thisRow + 1 End Select Next n End Sub. I can appreciate the developers getting paid for their efforts, but. Given that a QIF (or OFX) file is plain text then it can be read (and parsed) via standard VB[A] I/O methods/functions and so negates any point in paying for an app to do this, IMO. Using VB[A] I/O permits reading the QIF/OFX directly into an Excel worksheet, and allows one to customize the way the data displays in the process. If a CSV is required/desired then the Excel file can be saved as such at any time.

Usb to lan converter driver. It just seems a bit counter-productive (IMO) to buy an app, convert the QIF/OFX file so you can then import that CSV into Excel when it can be done in Excel in a single step, thus bypassing all that other nonsense! -- Garry Free usenet access at Classic VB Users Regroup! Comp.lang.basic.visual.misc microsoft.public.vb.general.discussion.

Click the “Install” button in Excel. Choose your language (English or French) and restart Excel.

Conversion Open your CSV data file in Excel and highlight all the data you wish to convert. Click the “Add-Ins” tab at the top of the Excel window. Click the XL2QIF button and select “Save to QIF.” Select the appropriate “Account Type” under “Options” in the window that pops up. It is “Bank” by default, but options like “Credit Card” and “Liabilities” exist.

Find the “Standard Field” box and check the fields in your CVS file in the order that they appear. For instance, a bank account might have the date, then the amount, then the category, etc. Click the “Browse” button and select where you would like to save your QIF file. Gotovie proekti archicad 16.

Click “Save” and then, back in the main window, “Convert.”.