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 23, 2007, 2:26 pm
Please log in for more thread options
 John Pollard keyed the following on 5/23/2007 12:48 PM:
> 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.

You're right. I took "print" literally and never thought it could also mean
"export formatted data to a file". Silly me! :-)

Thanks.

Posted by D T W .../\... on May 22, 2007, 9:51 pm
Please log in for more thread options
 The 2007 Premier version has:

In the Register view - click report, register report, right click, for a
drop down to choose Excel compatible format.

--
DTW .../.../.../...

> Is there a way to export the date in the check register to a spreadsheet
> file --
> tab- or comma-delimited or Excel?



Posted by Charliec on May 22, 2007, 5:27 am
Please log in for more thread options
Works pretty well!

wrote:

>The 2007 Premier version has:
>
>In the Register view - click report, register report, right click, for a
>drop down to choose Excel compatible format.
******************************************************
Charliec

Posted by Pikov Andropov on May 22, 2007, 5:56 pm
Please log in for more thread options
D T W .../... keyed the following on 5/22/2007 5:51 PM:
> The 2007 Premier version has:
>
> In the Register view - click report, register report, right click, for a drop
> down to choose Excel compatible format.
>


Nothing like that in 2005 Deluxe? There doesn't seem to be a way to get the
balance into a report.

Posted by John Pollard on May 22, 2007, 6:34 pm
Please log in for more thread options
Pikov Andropov wrote:
> D T W .../... keyed the following on 5/22/2007 5:51 PM:
>> The 2007 Premier version has:
>>
>> In the Register view - click report, register report,
>> right click, for a drop down to choose Excel compatible
>> format.

> Nothing like that in 2005 Deluxe?

> There doesn't seem to be a way to get the balance into a
> report.

Of course there is. Every Quicken "report" can be "exported" to
Excel.

In Q2005 there are generally three ways: click "Export Data" in
the report menu, then either "To Excel compatible format", or
"Copy to Clipboard" (then paste in Excel); or click "Print",
then click "Export to tab-delimited (Excel-compatible) Disk
File".

--
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