Re: Exporting a report to Excel

Hi Jack

simple answer is "you can't" - other than printing the only thing you can do
with Project's reports are to "print" them to a PDF format ... then copying
& pasting the output of the PDF document into Excel is an option - but it's
not always terribly successful.

Not sure how this goes for cash flow information, but another alternative
you might like to look at is analyze timescaled data in excel option - it's
on the analysis toolbar

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Jack Shearer" <nospamaylict@xxxxxxx> wrote in message
news:Wxy4e.1219$5F3.616@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks Dave, however what I want to do is export one of Project's standard
> reports to Excel (ie the Cash Flow report). It is already in the format I
> want and I can filter the contents down to what I need.
>
> I am trying to avoid having to reinvent the wheel. I have already done
> the
> work in Project, I just want to combine and manipulate the information in
> the Project with information that is external to to the project.
>
> Jack
>
> "davegb" <davegb@xxxxxxxxxxxxxx> wrote in message
> news:1112709126.422817.277190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> All you have to do is create a table with the data you want to export.
>> Then Copy and Paste into XL. If you want it hot-linked, do a Paste,
>> Special, Link Text.
>>
>
>


.

Relevant Pages

  • Re: Earned Value - month by month
    ... If you view the Task Usage View and use the "Analyze Timescaled Data in ... Excel" toolbar button on the Analysis toolbar, ... The reports clearly state that they cannot be exported and therefore ...
    (microsoft.public.project)
  • PHP (mysql) to Excel, Word and PDF and other report formats
    ... We have a php/mysql application in development and we have to product quite a few different reports. ... Some in Excel and Word format ... Some in PDF format ...
    (comp.lang.php)
  • Re: why>?
    ... easier to do in a spreadsheet than it is to do in Excel. ... I can produce portable reports in PDF form quite easily.. ... Spreadsheets are poor platforms for writing complex ... databases don't NEED to store a different formula for each row. ...
    (microsoft.public.excel)
  • Re: Existing forms to PDF or Excel
    ... > I saw that MS excel stores dates as an integer since 1.1.1900. ... Then just saved them as html format. ... >>> reports avail as Excel. ... >>> PDF as well as the option of hardcopy output. ...
    (comp.databases.pick)
  • Re: Existing forms to PDF or Excel
    ... I saw that MS excel stores dates as an integer since 1.1.1900. ... I also format identified this cell as "date". ... About 4 or 5 years ago I started to output all the companies reports to ... As far as PDF goes, my windows developer wrote his own report generator ...
    (comp.databases.pick)
Loading