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!

xlCol = (Asgn.Text1) Not Copying Contents 1

Status
Not open for further replies.

DAVEKELLY

Technical User
Apr 15, 2001
11
AU
I am copying Project 2002 data accross to Excel.
These work without any problems.
xlCol = (Asgn.Start)
xlCol = (Asgn.Work)

Can someone explain why I can't get (Asgn.Text1) to copy Text1 contents accross? What's the fix?

In Step mode,Text1 shows contents as "". Yes - Text1 does contain information.

Many Thanks
Dave K


 
Text1 actually appears in two areas in project: as a Task field and as an Assignment field.

Possibly you have data in one (the task Text1 field) but are attempting to access the other (the assignment Text1 field).
 
Of Course. Fixed the code to read Task.Text1 and it works as designed.

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top