Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export to MS Project
Hi,
I am trying to create VB code in excel that will 1. open a specific ms project file 2. select a range of excel data 3. update the ms project file 4. save and close the ms project file 5. return to excel Thank you for any help you can provide Cathy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export to MS Project
Cathy
You'll have to be more specific about numbers 2 and 3. Here's how you do numbers 1, 4, and 5. Sub DoProject() Dim prApp As MSProject.Application Dim prProj As MSProject.Project Set prApp = New MSProject.Application prApp.FileOpen "\\Pm1\c\WINDOWS\Desktop\Job Schedules\MtCalvary.mpp" Set prProj = prApp.ActiveProject 'Do numbers 2 and 3 prApp.FileSave prApp.Quit End Sub Set a reference (VBE - Tools - References) to the MS Project Library. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Cathy" wrote in message ... Hi, I am trying to create VB code in excel that will 1. open a specific ms project file 2. select a range of excel data 3. update the ms project file 4. save and close the ms project file 5. return to excel Thank you for any help you can provide Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export Exel task list into Project 2002? | Excel Discussion (Misc queries) | |||
Microsoft Project Export to Excel | Excel Discussion (Misc queries) | |||
Have 2 create 2 new date fields after export from MS project 4 piv | Excel Discussion (Misc queries) | |||
Export from MS Project to excel along with Gant Chart | Excel Discussion (Misc queries) | |||
Is there a way to export excel data into MS project? | Excel Discussion (Misc queries) |