creating macro to combine a dbf and create a wdp file

Hi all, I need some help with creating a macro and hope to find someone who is able to assist me.

I have an old dbf file with a lot of info in it, this info is also in a lot of AutoCAD Drawings in some attributes. I must create a wdp file now, thats for AutoCAD Electrical, this file must contain also som information that was in the past in the old dbf. (this dbf file is copied into the tab "PLANOS"

I wrote some info below that must be done in the excel file. I created also a macro but that results in doing the same again and again....?

Starting tab "Projectsettings" cell A114 must be placed a "'=" and behind a value thats in the tab "PLANOS"
On the next row A115 must be placed the value "'=="
On the next row A116 must be placed the value "'===" and behind a value thats in the tab "PLANOS" column LUGAR ( AC2)
On the next row A117 must be placed the value "'===" and behind a value thats in the tab "PLANOS" column DISPOS( AB2)
On the next row A118 must be placed the value "'===" and behind a value thats in the tab "PLANOS" column OBS1( R2)
On the next row A119 must be placed the value "'===" and behind a value thats in the tab "PLANOS" column OBS2( S2)
On the next row A120 must be placed the value "'===" and behind a value thats in the tab "PLANOS" column NAME( B2) followed with ".dwg"
The macro must run on every row until the value in the column Name is empty

see also attached xlsx file

Hans

This should work for you. I don't know why you started in row 114. I started in row 2 for the purposes of testing. You can change the start row in the code:

Please Login or Register  to view this content.

Also I assumed you wanted the generated data on the wdp sheet. Clear out the test data and copy in whatever header rows you need.

Also, I had to format column A as text, otherwise Excel was trying to interpret those equal signs as the start of a formula.