Locked excel report problem... Vb 6.0

[ips_sun]

hi my query is regarding Macros in Excelsheet! i have already an excel report generated from an application. which is locked.. i mean it is unedittable. i want to add few more columns in that report .. depdending upon already existing columns in the excel report. for example... TimeIn TimeOut above 2 r already existing fields in excel report. i want to generate two more columns depdendin upon the values in above 2 fields. First i want to ask is it possible to do this in locked excel report...if yes then how? if no then what is another alternative. Or as somebody adviced me to use macros, is it possible with macros? how to write such a macro... i haven't worked with macros! thanx in advance..!

[Paul Conrad]

What was it that you were trying to do?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus