gererate an excel table to specific cells

[alanled]

Im writing a table to an excel file template. The table generates 2 columns of data the problem is the excel template columns are not next to each other for example: column A= data,          column B=pre-written information,                   column C=data

at the moment the data is being written to A and B i need to write to A and C. How do I do this? I've tried locking the cells of column B but that doesnt work, any ideas please!

[smercurio_fc]

Are you actually using ActiveX or are you using the Write to Spreadsheet File function? If you're using ActiveX then why can't you just change your code to write to the correct column? If you're using the Write to Spreadsheet File function then just insert an additional tab between the two column values. The extra tab just shifts the second number by one column.

[alanled]

thanks for your reply, Im using the Report generation toolkit, i have given a start point (named cell) but I cant seem to find what I need to designate what cells to miss etc, as youve probably gathered I'm pretty new.

[smercurio_fc]

Does your template use named ranges? If not, then this is probably what you want to do. If you don't use named ranges then you can probably write out the report in 2 steps. First step write out column A, second step write out column C.