EXCEL ワークシート追加、セルの書式設定を文字列に
ワークシート追加
oBook.Sheets.Add(, , 1, )'(Before As Object,After As Object,Count As Object,Type As Object)
ちなみに
'移動 moveSheet.Move(,targetSheet)'(Before As Object,After As Object) 'コピー copySheet.Copy(,targetSheet)'(Before As Object,After As Object) '削除 oSheet.Delete()
セルの書式設定を文字列にするには
oRange.NumberFormatLocal = "@"