Cpoying summary task info

[Alexander Barvinsky]

Hi,
I recording macro wich havet to coptying to clipboard summary info from
summary task (row = 0)

Sub Report()
' Copying EV to clipboard
ViewApply Name:="Report"
SelectTaskField Row:=0, Column:="BCWS", Width:=9
EditCopy
End Sub

It work only if I use it from not "Report" view. If I select any row in
Report view and run macro it's copy to clipboard data from currently selected
row, not from 0. Ho to fix?

And another one question: can I format copting data?
After copying cells to the Excel I cant
Alerxander Barvinsky
pm4pm.org

 

[John]

Hi,
I recording macro wich havet to coptying to clipboard summary info from
summary task (row = 0)

Sub Report()
' Copying EV to clipboard
ViewApply Name:="Report"
SelectTaskField Row:=0, Column:="BCWS", Width:=9
EditCopy
End Sub

It work only if I use it from not "Report" view. If I select any row in
Report view and run macro it's copy to clipboard data from currently selected
row, not from 0. Ho to fix?

And another one question: can I format copting data?
After copying cells to the Excel I cant
Alerxander Barvinsky
pm4pm.org

Alexander,
Unfortunately, the built-in Reports in Project are for printing only.
They cannot be saved or copied (to the clipboard or anywhere else). I
suggest you use a view that shows what you see in the Report and then do
the copy.

Data can be formatted any way you desire. Why do you believe it cannot
be formatted in Excel?

Hope this helps.
John
Project MVP

 

[Alexander Barvinsky]

Alexander,
Unfortunately, the built-in Reports in Project are for printing only.
They cannot be saved or copied (to the clipboard or anywhere else). I
suggest you use a view that shows what you see in the Report and then do
the copy.

Data can be formatted any way you desire. Why do you believe it cannot
be formatted in Excel?

When I paste copied cells from MSP to the Excel with "paste special", I can't
operate with cells in clipboard as with copied cells from excel. I have to
insert them with Values and Transpose options. But I can insert them only as
object from MSP.


Alerxander Barvinsky
pm4pm.org

 

[John]

When I paste copied cells from MSP to the Excel with "paste special", I can't
operate with cells in clipboard as with copied cells from excel. I have to
insert them with Values and Transpose options. But I can insert them only as
object from MSP.


Alerxander Barvinsky
pm4pm.org

Alerxander,
Did I misspell your name? One place it shows Alerxander and another
place, Alexander. I'm not sure which is correct.

Why are you using "Paste Special"? Normally that is used for special
(but not very robust) linking or to insert an actual object (not
editable as I recall) into another application. If you simply want to
transfer data from Project to Excel and don't want to use VBA, then the
best approach is either an export map or a "straight" copy/paste. Once
the data is in Excel it can be edited/formatted either manually or via a
VBA macro in Excel.

Hope this helps.
John
Project MVP

 

[Alexander Barvinsky]

Did I misspell your name? One place it shows Alerxander and another
place, Alexander. I'm not sure which is correct.

Alexander

Why are you using "Paste Special"? Normally that is used for special
(but not very robust) linking or to insert an actual object (not
editable as I recall) into another application. If you simply want to
transfer data from Project to Excel and don't want to use VBA, then the
best approach is either an export map or a "straight" copy/paste. Once
the data is in Excel it can be edited/formatted either manually or via a
VBA macro in Excel.

I need to copy row with summary info from Project as column to Excel.
Now I do it in two steps
1. Just copy&paste info to the excel
2. Copy row in excel and place with Paste special as column
Alerxander Barvinsky
pm4pm.org

 

[John]

I need to copy row with summary info from Project as column to Excel.
Now I do it in two steps
1. Just copy&paste info to the excel
2. Copy row in excel and place with Paste special as column
Alerxander Barvinsky
pm4pm.org

Alexxxxxx,
Sorry, I'm lost. It sounds like you are trying to copy a row of Project
data and paste it into Excel as a column. As far as I know, that can't
be done, as least not easily. A row in Project will paste as a row in
Excel and a column in Project will paste as a column in Excel. To
convert row data to column data, each Project field will need to be
copied and pasted separately into a Worksheet cell in Excel.

Apparently I do not have a good understanding of exactly what you are
trying to do but if you are using Paste Special, as I said before, the
end result will not be editable.

John
Project MVP