P3 to Project through Excel

Thank you very much Hannes de Bruyne.



I am checking that post now.

Hello Gün



in the thread "from P3 to MSP" I explained something about makros - the "engine" behind the file "activity.xls".



Hannes de Bruyne

oh!



I’ll be very gratefull if anyone could send me some documents regarding the inerworkings of the activity.xls file.



I am trying to understand to way it really works.



any modified examples will be very much appreciated too.



Thanks.

Gün. :)

Beware though,



WK1 files have a maximum line capacity of somewhere around 2200. if you have more data (read more lines) you will loose them.



DBF files need to have the boundaries defined. otherwise they dont have any limits (that I know of) concerning the number of lines in the file. But its a pain to arrange & check the boundaries everytime you add some lines to it as excel does not reset to the correct values when it saves. so you may have some lost data there too if you are not carefull.



My experience is dbf is better if you have big files. wk1 is better as you dont need to check the boundaries of the file.



if you want to automate the process somewhat I suggest you use the activity.xls and brother files you can find in the cd. play with it (thats what I am doing at the moment) and after a while you will get a feeling for the macro codes in it. thus in the very long therm may be able to code all of the exchange.



hope this helps.

Gün. :)

Hi,



The good old Lotus (WK*) export is also good.



You can open the Lotus spreadsheet directly in Excel.





If you want a report in excel, you can export to CSV-file. Than import a CSV as a text file.





Regards,



Lex

Hi,



P3 can not see Excel file extensions (.xls). You have to save the Excel file into a .dbf (database file) in order that P3 can see it.



Use a P3 export file as a template for your excel file and when it is populated using the P3 headings you may inport it as a .dbf file