' Drive Type will display only the number depending upon the type of the Drive. Each number represent different things which is mentioned below in the Select case loop. ' The loop is only for the ...
strDirectory = "C:\New folder 1" objWorkbook.Sheets("MyTemp1").Range("A1").Font.Name = "Cambria" objWorkbook.Sheets("MyTemp1").Range("A1").Font.Bold = True ...