Home Page link  

Export entire check register to spreadsheet?

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Export entire check register to spreadsheet? Pikov Andropov 05-22-2007
Posted by Pikov Andropov on May 22, 2007, 11:22 am
Please log in for more thread options
 Is there a way to export the date in the check register to a spreadsheet file --
tab- or comma-delimited or Excel?

Posted by Pikov Andropov on May 22, 2007, 5:57 pm
Please log in for more thread options
 Pikov Andropov keyed the following on 5/22/2007 11:22 AM:
> Is there a way to export the date in the check register to a spreadsheet file
--
> tab- or comma-delimited or Excel?

Oops!! DATA, not date. Sorry.

I;m most interested in the running balances.

Posted by Han on May 23, 2007, 6:10 am
Please log in for more thread options

> Pikov Andropov keyed the following on 5/22/2007 11:22 AM:
>> Is there a way to export the date in the check register to a
>> spreadsheet file -- tab- or comma-delimited or Excel?
>
> Oops!! DATA, not date. Sorry.
>
> I;m most interested in the running balances.
>
From the register:
Ctrl-P
Set dates, fill in boxes, click print then choose excel format. Call the
file test.prn. Make sure the file does not get .txt added as an additional
suffix. If necessary, rename.

Double-click the file name in explorer and make sure it is opened with
Excel.

Works with Q2006, and does give running balances.
--
Best regards
Han
email address is invalid

Posted by Pikov Andropov on May 23, 2007, 12:13 pm
Please log in for more thread options
Han keyed the following on 5/23/2007 6:10 AM:
<snip>

> From the register:
> Ctrl-P
> Set dates, fill in boxes, click print then choose excel format.

Aha!!! Thanks.

Posted by John Pollard on May 23, 2007, 4:48 pm
Please log in for more thread options
Pikov Andropov wrote:
> Han keyed the following on 5/23/2007 6:10 AM:
> <snip>
>
>> From the register:
>> Ctrl-P
>> Set dates, fill in boxes, click print then choose excel
>> format.
>
> Aha!!! Thanks.

Which, except for the Ctrl-P part (a shortcut which produces the
same "Register" report I mentioned earlier), is *exactly* what I
told you to do ... to which you replied that you did not want to
"print" a report. Notice the word "print" in the instructions
that you are replying to here? Now, you do not find any problem
"print"ing a report ... before, same basic instructions ... it
was a problem.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup




Similar ThreadsPosted
Quicken 2006, any way to export register to Excel? September 5, 2007, 11:41 am
Check Register Much Too Large December 10, 2006, 4:27 pm
Check Register Window Question Please December 31, 2007, 9:32 am
Payee Duplicates in Check Register May 14, 2006, 2:56 am
Red and White Check in Register 2008 April 28, 2008, 9:11 pm
QIF EXPORT August 23, 2006, 12:26 pm
QIF--export/import November 11, 2007, 1:06 am
Import-export question August 6, 2006, 12:21 am
select accounts to export? August 30, 2006, 9:33 pm
Export in H&B 2007 Australian June 1, 2007, 7:18 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap