COM ADD IN in microsoft project to save project into mssql

[myra]

I'm currently using shared add-in to develop a COM Add-in to be on MS
Project. When user clicked on it, it will save the entire project in MS SQL.
The problem is, I found a way to manually do it step-by-step using ODBC,
however, I want to use a single button to automatically save the project
instead of letting the user click through those steps. Is there a way to do
it? I am currently using MS Project 2003 with VB.NET. Thanks a lot.

 

[Rod Gill]

Hi,

In 2003 you can save to any ODBC source by creating a DSN. In 2007 you have
to use code.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[myra]

yup...we are using ms project 2003 and managed to create a DSN, the thing we
wanted to develop is actually a COM ADD IN button that can enable us to save
directly to the mssql without follow the steps: file->save->odbc->select the
dsn name. Is it possible? For the ms project 2007, is there any website i can
browse through to get some codes for references?

 

[Rod Gill]

So what happens when you record a macro doing these steps?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[myra]

We tried it, but if we use macro, everytime we create new ms project, it will
be save as a same file, overwrite the data we save before. IS there any
suggestion how we can save the new file under same database but different
file name? thanks..

 

[Jack Dahlgren]

The code you get from recording the macro is the best starting point. Just
change the parameters (filename most likely but may need some other tweaks)
so that is uses a unique filename.

-Jack Dahlgren