LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 201
Default Ms Project to Excel Linked

Hi everyone
Lots of great info on here and help,
My problem is I have a Ms Project File which gets updated
New Lines inserted and deleted in the project file
I need certin information to export to excel and then further work happens
in excel from there (which is ok)
The problem I have is if there is more data added in the project file, it
does not automatically come through into the excel file
I don't want to do an export to new file every time if I can help it.
I have a paste link from project to excel in excel8.0 link type if that make
sense

Does anyone have any code or ideas of what I could use to keep the 2 files
in sync.
I can add some extra columns in project like UniqueID and an Export Date,
but that doesn't help me with the new lines at the moment

Any Idea would be very much appreciated, I can put up the code I have so far
and the files for amy one to look at

Thanks for your help
Phil Keoghan


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project - VBA Project window - Excel 2003 Jarek Kujawa[_2_] Excel Programming 9 October 1st 09 08:00 AM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
Linked Budget Worksheets - What to do when Project Shifts in Time? RavenPM Excel Discussion (Misc queries) 1 June 10th 07 06:52 AM
How to convert MS Project to MS Excel. I don't have MS Project. Jane Excel Discussion (Misc queries) 1 February 20th 06 10:01 PM
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. Tony Excel Programming 1 October 18th 05 03:53 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"