One easy way would be to tonvert it to a csv file that you couls import:
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A1:A6").Select
Selection.Copy
Range("B1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Application.CutCopyMode = False
Range("B1:G1").Cut Destination:=Range("A1:F1")
Range("A2:A6").Select
Selection.ClearContents
Range("A1").Select
ActiveWorkbook.SaveAs Filename:="C:\Book1.csv" _
, FileFormat:=xlCSV, CreateBackup:=False
End Sub
Bookmarks