Import Project codes?

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.

This forum doesn’t support slash symbol.

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

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



Thanks once again.

Hi, there

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

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.

All a.m. utilities you can download from here:

http://rapidshare.de/files-en/489358/P3_excel.zip.html

Best regards,

Andrew

D:SUPPORT/UTILS/EXCEL/activity

Will give you the ability to import Codes & Descriptions from xls

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

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

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.