VB is there any way to an excel data import can't change the excel in another format?
Table A is A derived from software Excel (income statement), table B is A format cannot change forms, there are A few book, one of the income statement,
Now I want to import the data from the list A table where the 2 B workbook,
In fact, is there any way can be implemented?

CodePudding user response:

Just copy and paste

CodePudding user response:

According to the numerical paste special!
To record a macro to have code, according to your file name, work table name adjustment,

 Dim SRC As Worksheet 
Dim DST As Worksheet 
Set the SRC=https://bbs.csdn.net/topics/Workbooks (" A ".) Sheets (" interest table ") 
Set the DST=Workbooks (" B ") Sheets (" interest table ") 
The SRC. Cells. Copy 
DST. Cells. PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _ 
SkipBlanks:=False, Transpose:=False