R
RLN
Re: Excel 2003
Hello.
I have this code from a macro and am looking to streamline it:
<begin macro>
Columns("A:A").Select
Selection.NumberFormat = "General"
Columns("B:B").Select
Selection.NumberFormat = "General"
Columns("C:C").Select
Selection.NumberFormat = "General"
Columns("D").Select
Selection.NumberFormat = "@"
Columns("E:E").Select
Selection.NumberFormat = "@"
Columns("F:F").Select
Selection.NumberFormat = "General"
Columns("G:G").Select
Selection.NumberFormat = "@"
Columns("H:H").Select
Columns("I:I").Select
Selection.NumberFormat = "@"
Columns("J:J").Select
Selection.NumberFormat = "0"
Columns("K:K").Select
Selection.NumberFormat = "0"
<end macro>
I am not sure how to set up code to loop through an .XLS file to get the
sheetname, count the valid columns and rows (column/row numbers can
change from month to month)
Then as I loop through each column if it is A,B,C, or F then set
numberformat to "General", etc.....
Do I have to invoke the Excel Object -and- the Workbook object, -and-
the sheet object? This is where I get confused.
Thnx....
*** Sent via Developersdex http://www.developersdex.com ***
Hello.
I have this code from a macro and am looking to streamline it:
<begin macro>
Columns("A:A").Select
Selection.NumberFormat = "General"
Columns("B:B").Select
Selection.NumberFormat = "General"
Columns("C:C").Select
Selection.NumberFormat = "General"
Columns("D").Select
Selection.NumberFormat = "@"
Columns("E:E").Select
Selection.NumberFormat = "@"
Columns("F:F").Select
Selection.NumberFormat = "General"
Columns("G:G").Select
Selection.NumberFormat = "@"
Columns("H:H").Select
Columns("I:I").Select
Selection.NumberFormat = "@"
Columns("J:J").Select
Selection.NumberFormat = "0"
Columns("K:K").Select
Selection.NumberFormat = "0"
<end macro>
I am not sure how to set up code to loop through an .XLS file to get the
sheetname, count the valid columns and rows (column/row numbers can
change from month to month)
Then as I loop through each column if it is A,B,C, or F then set
numberformat to "General", etc.....
Do I have to invoke the Excel Object -and- the Workbook object, -and-
the sheet object? This is where I get confused.
Thnx....
*** Sent via Developersdex http://www.developersdex.com ***