VBA code for document controll & progress monitoring

Closed
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013 - Jun 16, 2013 at 04:44 AM
 j108 - Jun 22, 2013 at 03:52 AM
Hi...

Good day!

I am a project control engineer dealing with almost 1500 documents/drawings from my engineering sub contractor.

Each document is given a document id which is unique.

Each document is having a weight value.

When the subcontractor submits the document to me the progress is 50% of weight value.

when we submit for client review our progress is 70%



We are having planned and actual dates for submissions.

Can some one suggest a program using VBA codes for controlling this documents and
progress monitoring

10 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2013 at 09:33 AM
To me, your question is very ambiguous. The best that I could understand was
1. You have a master file where each document information is listed and each document is given id.
2. when document comes back from sub contractors, you update that file
3. when same document returns back from client, you again update that file

I am sure thats is not what you want.So could you again explain
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 16, 2013 at 10:09 AM
Thanks rizvisa 1 for your response....

Your assumptions are right.....

is there any option here for me to upload sample excel file so that i can explain very easily
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2013 at 10:14 AM
You have to use some public file share site and post back the link to the FILE ITSELF back here
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 16, 2013 at 10:40 AM
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 16, 2013 at 10:54 AM
The dates in red color are actual submission dates and are updated manualy which is time consuming.........

Any macro which can help me to update this file from the file received from subcontractor having document no and having Start, DRAFT/ Preparation, Issued For Internal Review, Issued To Company, Company Reply, Free Issue as IFC, As-Built dates

Thanks!
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2013 at 11:41 AM
So is it correct to say that you want to have some thing that can update the date and time
Does the file that you get from the contractor has same information.

Most easy way that comes to my mind is that, you have on each file a sheet that contain all the information that you want to be pulled out. So user only update that sheet. You macro can then loop through all the workbooks. Since you said it is engineering stuff, I am guess not all documents are not workbook

Presuming that the "PIB" part is locating and updating the values, the alternate way could be that in a new sheet you enter the document id and the date and some code to indicate that this date refers to what milestone, then you can have a macro that uses this list, match up the document id and update the dates
0

Didn't find the answer you are looking for?

Ask a question
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 17, 2013 at 09:16 AM
Thanks rizvisa!

Now i have loaded sample source file in public in which Rev and actual dates will be updated by the subcontractor.

This information (Rev & actual "A" dates )we need to update in master

The column "type" in master file can be changed to "Rev".

Now we need a macro for updating master file from source file.

Note:COWI/TRAGS Doc number is our document ID.

Could you plese help me?
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 18, 2013 at 12:49 AM
Hai..rizvisa!.....

Any updates?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 18, 2013 at 06:41 AM
I am sorry but now I am bit more lost. The workbook that you posted, I am presuming is the master sheet. How does contractor sheet would look like from where the information needs to be copied. Since you want information to be lifted off the contractor copy of document, one has to see how two can be tied together
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 18, 2013 at 10:13 AM
Thanks rizvisa1!

Now i have removed previous files from public and loaded new master file & subcontractor file.

Our target is to develop a macro to update master file columns "Rev" and all actual "dates" from the subcontractor file.....
0
j108 Posts 8 Registration date Sunday June 16, 2013 Status Member Last seen June 19, 2013
Jun 19, 2013 at 01:22 AM
0
Dear rizviza 1,

Any updates?

Thankyou very much
0
Dear rizviza1..

Can you please help me......

j108
0