|
|
|
date: Sun, 17 Aug 2008 18:39:20 -0700 (PDT),
group: microsoft.public.project.developer
back
Re: Excel and WorkSpace: is possible to generate a file and save it
in the workspace?
On Aug 18, 10:49 pm, John wrote:
> In article
> ,
>
> Vit wrote:
> > 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
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
date: Mon, 18 Aug 2008 08:59:36 -0700 (PDT)
author: Vit
Re: Excel and WorkSpace: is possible to generate a file and save it in the workspace?
In article
,
Vit wrote:
> On Aug 18, 10:49 pm, John wrote:
> > In article
> > ,
> >
> > Vit wrote:
> > > 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
>
> 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
date: Mon, 18 Aug 2008 13:20:45 -0700
author: John
|
|
