How can i make 1 transaction = 1 workbook to process in a list of multiple workbooks in a file? If i use the Directory.GetFiles, I’m assuming it will not treat one workbook as one transaction.
Change the transactiondata variable from datatable to string array and assign directory.Getfiles result to it
change transactionitem to string
And in gettransactiondata.xaml use if condition with in_transactionnumber<=io_transactiondata.count
On lect side use out_TransactionItem= io_transactiondata(in_transactionnumber-1) and on else side use out_transactionitem = nothing
Hope this helps
Cheers
1 Like
That worked. Many thanks.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.