Excel and WorkSpace: is possible to generate a file and save it inthe workspace?

[Vit]

Hi All,

I'm working on a macro that should link some field in excel, and
automatically save the file in the right workspace...

is it possible???

how can I do it??

thank you so much

Cheers

Vit

 

[John]

Hi All,

I'm working on a macro that should link some field in excel, and
automatically save the file in the right workspace...

is it possible???

how can I do it??

thank you so much

Cheers

Vit

Vit,
Is this an Excel question? If so, you've posted to the wrong newsgroup.
This newsgroup is devoted to Microsoft Project, a planning and
scheduling application.

If this is a question related to Microsoft Project, you'll have to
explain it a whole lot better than you have in order for us to help you.

John
Project MVP

 

[Vit]

Vit,
Is this an Excel question? If so, you've posted to the wrong newsgroup.
This newsgroup is devoted to Microsoft Project, a planning and
scheduling application.

If this is a question related to Microsoft Project, you'll have to
explain it a whole lot better than you have in order for us to help you.

John
Project MVP

sorry, you are right.....

I'd like to generate a macro (in project) that creates an excel file
with some task linked (so I can perform some analysis) and
automatically save it in the relative workspace....

I hope this better explain my problem...

the macro shuld:

- open excel
- save the file in the workspace
- copy and paste task (from project to excel - as link)
- copy and paste some fields (from project to excel - as link)
- copy and past some columns (from excel to project - as link)

thanks for the help.... I think that this is a macro in project....
isn't it???

thanks

Cheers

Vit

 

[John]

sorry, you are right.....

I'd like to generate a macro (in project) that creates an excel file
with some task linked (so I can perform some analysis) and
automatically save it in the relative workspace....

I hope this better explain my problem...

the macro shuld:

- open excel
- save the file in the workspace
- copy and paste task (from project to excel - as link)
- copy and paste some fields (from project to excel - as link)
- copy and past some columns (from excel to project - as link)

thanks for the help.... I think that this is a macro in project....
isn't it???

thanks

Cheers

Vit

Vit,
There is a much more efficient approach than using copy and paste to get
data from Project to Excel. And I certainly do not recommend you do it
as a paste link since that will only open you up to a greater
possibility for corruption.

I don't have the time to detail out the code to programmatically export
Project data to Excel although there have been various posts on this
newsgroup in the past that outline the structure. It also sounds like
you want to do some analysis of the data in Excel and that can be
incorporated into the code as well. The end result would be an export of
data and automated analysis, all in one macro.

If no one else posts the necessary code directly, I suggest you get a
copy of fellow MVP, Rod Gill's, book on Project VBA. It has a couple of
good examples for doing the type of export you want. You can find out
more about Rod's book at, http://www.projectvbabook.com.

John
Project MVP

 

[Martin Winzig]

http://projectserver.cz/cms/index.php?itemid=4

Check out this article, it's for MS world but there is nice sample which
retrieve information from project server and then save World documet to
selected workspace.