Export to MS project

[Gilgamesh4Ever]

Hi there,
I've got a group of tasks defined in my application adn hosted in an MS SQL
server 2000. I would need some kind of component or API which allows me to
export these tasks into a valid MS project file. Anybody has done something
like this?

Thanks,
Gilgamesh

 

[Jan De Messemaeker]

Hi,

If you can refer to the MS project Application and activate it you have all
the objects you need.
HTH

 

[Gilgamesh4Ever]

I'm using the followng code to create an instance of MS project Application
but it fails
Set oProject = server.CreateObject("MSProject.application")

Any idea why this is happening?
Thanks,
-G

 

[JackD]

Sub OpenProject()
Dim pjApp As MSProject.Application
Dim myProj As MSProject.Project
Set pjApp = New MSProject.Application
pjApp.Visible = True
Set myProj = pjApp.Projects.Add
myProj.Tasks.Add ("My New Task")
End Sub

 

[Gilgamesh4Ever]

The code works great if used within a VB executable, but it throws error
when used within an ASP page. The error is generated at "Set pjApp = New
MSProject.Application" indicating that the activex can not be created.
-G

 

[JackD]

Is project installed on the server?

 

[Gilgamesh4Ever]

Yes.
-G

Is project installed on the server?

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.
in