I successfully change the font specs, but am unable to change the column width.
Here is the code I tried:
excelApp.Visible = True 'if TRUE, won't overwrite older versions excelWS.Range("A1", "K1").Select With Selection.Font .Size = 12 .Bold = True .Name = "Garamond" ' .colWidth = 20 ' .Width = 20 excelApp.Visible = False 'if TRUE, won't overwrite older versions End With
Any ideas about the Column width?
mod: email removed
This post has been edited by modi123_1: 14 June 2014 - 12:13 PM