Snasui Excel Forum

ไฟล์ตัวอย่างค่ะ

ExcelApp.Workbooks.Open("C:\1234.xlsx")

ExcelApp.Worksheets("sheet1").Select()



ExcelApp.Worksheets("sheet1").Range("B3 : D10").Select()

ExcelApp.ActiveSheet.Copy()


ExcelApp.Workbooks.Open("C:\4567.xlsx")


ExcelApp.Worksheets("sheet1").Range("A3 : C10").Select()

ExcelApp ...

Public Class Form10

Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
Form1.Show()
Me.Hide()

End Sub

Private Sub Button5_Click(sender As Object, e As EventArgs) Handles Button5.Click
Form1.Show()
Me.Hide()

End Sub

Private Sub Button1_Click(sender As ...