Seek help from your leadership explaination to a task, hands have a excel form, hope to design a small program, using vb6.0 by use in small program design two testbox area can write line and column number, then you can specify a line and column number area A1 - through F15 area, through to click a commandbutton can copy the data in a new sheet of the same excel table,
I have never used vb, so the fundamental principle of don't understand, I hope you advice,,, to make a finished product,,, grateful

CodePudding user response:

Please help, urgent,,,

CodePudding user response:

Use Excel VBA can also, basic programming, baidu will tell you how to do it, or you need to describe clearly

CodePudding user response:

Give me the salary, I to do,
1, create objects: createobject (" Excel. Application ")
2, open the Excel
3, select the A1: F15
4, copy
5, create a new Excel file
6, paste

CodePudding user response:

Dim oExcel As New Excel. Application
The Set oExcel=Excel. Application
OExcel. Visible=False
The Set oBook=oExcel. Workbooks. Open (App) Path & amp; "\ Lin. XLS")
The Set oSheet1=oBook. Worksheets (" delegate ")

Aa=oExcel. Sheets (" delegate ".) Cells (I, 1) 'directly read

Mybb=oExcel. Range (oSheet1. Cells (1, 1), oSheet1. Cells (10, 20) 'batch read