Vb problem can use "a" and click "next" to achieve on an Excel spreadsheet cell-CodePudding

Say the next will be read. The cells (1, 1) point a will read. Cells (2, 1)

But these cells are in the same Excel in the document

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

Can't in Excel, want to click on a and under in vb a switch to read the content

CodePudding user response:

If two keys are defined in the Excel object will cause memory has two Excel. Exe

CodePudding user response:

reference weixin_39432996 reply: 3/f

if two keys are defined in the Excel object will cause memory has two Excel. Exe

Possible,
But a process, we should define a module level (or global) App object references, when using, only need to open a Excel process line,
If it is a "process", after the proposal is "used up", to invoke. The Quit interface, withdrew from the process, to release the object reference,
But such operations require frequent start, exit, poor user experience (because when you open the "card"),

Read data, why is "one cell at a time"?
A set of data read is obviously ought to be "a" (may be 1 row data, can also be multiple lines)...

CodePudding user response:

Is a read a set of data, but feel Excel constantly switch is too slow, reading speed is slow, poor user experience

CodePudding user response:

reference 4 floor Chen8013 response:

Quote: reference weixin_39432996 reply: 3/f

If two keys are defined in the Excel object will cause memory has two Excel. Exe

Possible,
But a process, we should define a module level (or global) App object references, when using, only need to open a Excel process line,
If it is a "process", after the proposal is "used up", to invoke. The Quit interface, withdrew from the process, to release the object reference,
But such operations require frequent start, exit, poor user experience (because when you open the "card"),

Read data, why is "one cell at a time"?
A set of data read is obviously ought to be "a" (may be 1 row data, can also be multiple lines)...

if throughout the form or define a Excel application but feel after the electric release, too,,, my idea is to open the window will automatically open an Excel file, there is also a form exists when Excel, exit Excel process disappear, Excel in the middle in the form of operation process are there

CodePudding user response:

Simply put the Excel save as. CSV,

CodePudding user response:

Explicitly give the operator a choice of excel file where no,
Picking the file, open the only operating here, define a current row variable N, initialize the default in the first row, then the next N=N + 1 on a N=N - 1, in the border control well yourself, don't take to the column head or make a negative or in excess of the maximum number of lines what what what, then every change N take cells (N, do you want to take the column), to solve the problem, program shut down or the operator to choose another excel file to close the current excel, don't need frequent switch,

CodePudding user response:

To the upstairs
Or can use the current line parameters corresponding plus 1 minus 1 operation
Dim as integer I
I=the Ex. ActiveCell. Row
I=I + 1
If the Ex. Cells (I, 1) & lt; & gt;" "Then
Ex. Cells (I, 1). Select
.
End the if

CodePudding user response:

Check the VBA macros

CodePudding user response:

Can change the train of thought, once you read it a list of all the data read back first and then on another, the next directly from all return don't read the data set is ok? This need not always open the excel object,