Hello people,
I have some drawing list of the project and that will be changed because of the revisions and statements and the new ones of course.
[TABLE="width: 266"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]05.02-2602-06-0001[/TD]
[TD]E10[/TD]
[/TR]
[TR]
[TD]05.02-2602-06-0002[/TD]
[TD]E09[/TD]
[/TR]
[TR]
[TD]05.02-2602-06-0003[/TD]
[TD]E11[/TD]
[/TR]
</tbody>[/TABLE]
First column is the drawing numbers and the second one is revision numbers. Can you help me to proceed in how can I create a code that combine this in "05.02-2602-06-0001_E10" format and search for it in a spesific folder whether it exists and write "Yes" or "No" in another column.
It sounds easy when I searched others which are similar to this, but I have no idea about VBA. Can you help or direct me to a place, this is one year job, it will be a baseline for me.
[TABLE="width: 266"]
<colgroup><col><col></colgroup><tbody></tbody>[/TABLE]
I have some drawing list of the project and that will be changed because of the revisions and statements and the new ones of course.
[TABLE="width: 266"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]05.02-2602-06-0001[/TD]
[TD]E10[/TD]
[/TR]
[TR]
[TD]05.02-2602-06-0002[/TD]
[TD]E09[/TD]
[/TR]
[TR]
[TD]05.02-2602-06-0003[/TD]
[TD]E11[/TD]
[/TR]
</tbody>[/TABLE]
First column is the drawing numbers and the second one is revision numbers. Can you help me to proceed in how can I create a code that combine this in "05.02-2602-06-0001_E10" format and search for it in a spesific folder whether it exists and write "Yes" or "No" in another column.
It sounds easy when I searched others which are similar to this, but I have no idea about VBA. Can you help or direct me to a place, this is one year job, it will be a baseline for me.
[TABLE="width: 266"]
<colgroup><col><col></colgroup><tbody></tbody>[/TABLE]