Two Excel have same columns and cell format, while use append range, the second excel “invoice date” change from General to Date, how to solve this issue?
I want to still keep General format.
B1_TestUse.xls (28 KB)
A1_TestUse.xls (28 KB)
append excel.xaml (7.7 KB)
Remark: I need to append “B1_TestUse.xls” into “A1_TestUse.xls”
Try this approach
Xaml for reference
AppendRangeWithGeneralFormat.xaml (4.8 KB)
I tested and found your method ok, can you give the reason why I use excel scope failed ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.