editing existing macro to add new column

**dnmahendra** · 11-03-2010, 05:22 AM

there is a sheet which gets data from the databasae(sybase). A new column needs to be added which also gets data from database. the point is i couldn't find the code in the application which was used to design existing sheet. so i couldn't add this column.
can anyone help on this?

**Bob Phillips** · 11-03-2010, 05:33 AM

Maybe it is using Query?

**dnmahendra** · 11-03-2010, 05:50 AM

hi , i have added the attachment. please go through it and guide me
i'm really in need of help.

**Bob Phillips** · 11-04-2010, 06:24 AM

But that is just a picture in Word, can't do much with that.

**dnmahendra** · 11-07-2010, 05:00 AM

if I attach the excel file can you open it. because it takes windows authentication and connects to the database the moment it is opened. I attached that word document so that it m ight give some idea what I am asking.