03-01-2009, 11:36 AM
My mistake earlier I did not told you that a new file will be created so the first one will not work. How can I convert a excel macro to QM. Just provide me an example where the opened excel file columns are selected and format is set to "0.00". VB code this will be :
Range("E:E,G:G,I:I,J:J,K:K,L:L").Select
Range("L1").Activate
Selection.NumberFormat = "#,##0.00"
Range("E:E,G:G,I:I,J:J,K:K,L:L").Select
Range("L1").Activate
Selection.NumberFormat = "#,##0.00"