re: How Can I Copy Data From One Spreadsheet to Another?

Matt — Mon, 11 Oct 2010 16:23:34 GMT

ScriptingGuy,

Your articles are very helpful... thanks for posting them. I am kind of stuck though and I am hoping that, even though it is several years down the road, you might be able to help.

I am trying to do what you explained above (which sadly I hadn't found this article when I started it) but it is acting strangely. The copy and paste works fine but the column widths are the defaults. If I try to change them it still doesn't match to what my template is. The code I used for that is below.

t_cols = db.Worksheets(ws).Range(db.Worksheets(ws).PageSetup.PrintArea).Columns;

rng = s.Range(t_rng.Address).Columns;

for(var n=1; n<=t_cols.count; n++)

{

rng.item(n).EntireColumn.ColumnWidth = t_cols.item(n).ColumnWidth;

}

It is also doing the same thing with borders... Is there a way that I can fix this (preferably when copying)? The only thing I can think of that is different between your article and what I've done is that they are in the same Excel.Application. Would that matter?

Thanks,

-Matt