Need help to connect two functions variables to each other

[elmnas]

Hi guys,

I have wrote following scripts,

the first one LoopFiles

It loops through files in a folder
if the filename contains: "NoTrans.xls" filter then the name
example of files can have name:
Test_sv.xls
Test_sv_NoTrans.xls
then the script open Test_sv.xls


see code below:

Please Login or Register  to view this content.

The thing is I want to merge the data from "Test_sv_NoTrans.xls" into the file "Test_sv.xls"


I have wrote this function to do this:

Please Login or Register  to view this content.

now is the problem.

while I run the script LoopFiles()

I need to connect the variable
MYLangFile

to the variable in Contentpaste()
SourceFile

and also connect the variable from Loopfiles()
myNoTransfile to the variable TargetFile.


see picture

bilden.jpg



I tried to this but I dont get it work,


Could someone help me to modify the code so the script works?

Thank you in advance

[Kaper]

How about:

Please Login or Register  to view this content.

[elmnas]

Could you please write the whole code correct I don't make it work?

Thank you in advance.

[Kaper]

Try:

Please Login or Register  to view this content.