|
なんとなく不必要っぽいところを削ってみたけど。
必要なのはフォントサイズだけ?
Sub Macro1()
Application.ScreenUpdating = False
With Cells
.Orientation = 0
.AddIndent = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Rows("1:3").Delete Shift:=xlUp
Range("A:A,D:D,E:E").Delete Shift:=xlToLeft
Range("A1").Value = "コード"
Range("A1").Font.Size = 9
With Range("B1")
.Value = "取引先名"
.Font.Size = 9
.Characters(1, 2).PhoneticCharacters = "トリヒキ"
.Characters(3, 1).PhoneticCharacters = "サキ"
.Characters(4, 1).PhoneticCharacters = "メイ"
End With
With Range("C1")
.Value = "銀行"
.Font.Size = 9
.Characters(1, 2).PhoneticCharacters = "ギンコウ"
End With
With Range("E1")
.Value = "消費税(A)"
With .Font
'.Name = "MS Pゴシック"
'.FontStyle = "標準"
.Size = 9
'.Strikethrough = False
'.Superscript = False
'.Subscript = False
'.OutlineFont = False
'.Shadow = False
'.Underline = xlUnderlineStyleNone
'.ColorIndex = xlAutomatic
End With
.Characters(1, 3).PhoneticCharacters = "ショウヒゼイ"
End With
Sheets("Sheet1").Name = "支払DB"
ActiveWorkbook.SaveAs Filename:="C:\支払DB.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Application.ScreenUpdating = True
End Sub
|
|