MS project 2003 - can't copy the ID field

R

Rohini

hi all

I've written the following to copy rows from MS Project into Excel:

....
pj.Application.SelectSheet
pj.Application.EditCopy
' in Excel
Range("A1").Select
ActiveSheet.Paste
....

The code copies the row displayed in Project into Excel, except for the
(task) ID column.

I've tried opening another ID column, but column "A" is still blank in
Excel, and the ID will be copied in column "B". (ie.: it will move
across one column).

Any ideas on how I can copy a row, including the task ID from Project
to Excel? The code above worked for MS Project 98 and 2000....

Many Thanks!
 
M

Mike Glen

Hi Rohini ,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 
C

Catfish Hunter

It sounds lile your ID column is locked. Go to View>Tables>More Tables and
edit the one you wish to export. There is an option to unlock the first
column. This may be your problem.
Also be aware there is a Unique ID you can also use. This number never
changes!!
Good Luck.
 
R

Rohini

thanks for this suggestion. I got up to View>Tables>More Tables but the
ID field wasn't on the list to be edited. I also couldn't see any
option to unlock the first column. I'm fairly new to all of this this
-can you please provide a bit more information on how I can unlock the
first column in MSP 2003?
 
C

Catfish Hunter

View>Tables>More Tables>EDIT (This is where you make changes). A table is
nothing more than the columns you see on the screen. Under the EDIT you can
lock or unlock the first column. The first column is defined by you. It can
be anything available in Projects. If your ID is locked it will be gray on
your screen.
Additionally a VIEW is made up of a Filter and a Table. If you edit a view
you can see this.
See if this clears up your problem. Good Luck!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
External Dependencies - Using Unique ID? 5
Linking external issue IDs to a task in MS Project 2003 server 3
2003 SP2 MS Project Excel Paste 3
MS Project Master Project Resource Allocation 1

Top