Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paste Data From MS Project 98 To Excel

Status
Not open for further replies.

Kevsim

Instructor
Apr 18, 2000
385
AU
I have also placed this post in VB for applications.
I am writing a macro in Microsoft Project 98, where I copy some data and past into Excel.
I have reached the point where the copy is OK and I can open a specific spreadsheet.
I have been unable to find the code so the data will paste into Excel.
All I want to do is pick a cell and paste the data.
I would appreciate some asistance.
kevsim
 
I'm not a VB guru ... when I had to do something similar to this I used Excel as the main application. I'd launch Excel and start the Excel macro. That macro started Project, let Project open the plan and then Excel copied the information from Project into Excel and then did any subsequent manipulation in Excel.

But that was some time ago and I can't find the code right now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top