I am trying to write a script in which I copy a file, open the new one, then delete the data in certain tables in order to run an import script that bring that data in from a set of excel files.
Here is what I have so far - in JPEG attached
I thought that I could use the $NewPathWin variable as the file name in the open file dialogue. But FM does not seem to accept variables here. Insight on how to deal with this will be much appreciated.
I will add the table update steps once I have the new file open.