Import Project codes?

Supplied with P3 are some utilities to do exactly this. If you dont have the original CD, PM me and I’ll forward a copy.

Hello Steven,
I only have an evaluation CD; what i sthe name of the file, I’ll have a look
Alexandre

I dont recall the name of the file, but they are *.xls, with macros written to import/export activity codes, resources and WBS.

D:SUPPORTUTILSEXCEL

ACTIVITY


This will allow you to export/import the Code & Description. If you jou want to assign act codes to an activities you can just export a norml wk1 file and ensure that you have ask for activity id & activity codes

Cheers

Guys,
I am looking for a way to import PROJECT CODES from some Excel or Lotus 123 file to P3.
It looks like it’s only possible to export / import activity / resources custom data items.
Any idea?

D:SUPPORT/UTILS/EXCEL/activity
Will give you the ability to import Codes & Descriptions from xls

Hi, there.
All a.m. utilities you can download from here:
http://rapidshare.de/files-en/489358/P3_excel.zip.html
Best regards,
Andrew

I checked the spreadsheets. For the spreadsheet to work is it necessary that p3win directory exists in the C directory or will it work even if the p3win directory exists in any other subfolder in the c: directory. It just displays exiting RA as soon as I run any macro.

Can anyone help?

Thanks

Hi, there
Make sure P3 is already running on your computer (even with no project opened). That may help.

Thanks. But I get an error 501111, file not found. Any ideas?

Thanks once again.

Go to debug mode and check the vba code. I’m pretty sure that something wrong with project path or project name.
Be aware - you have to put short path in any Macro.
For instance:
c:progra~1 instead of c:Program files
Don’t hesitate to contact me personally.
Best regards
Andrew

This forum doesn’t support slash symbol.

Hi there Andrew,

We have tweaked the code so that it will (hopefully) show the slash, i.e. the \\\\\\\\\ character.

Thanks for the observation.

PP Admin.